
July 15th, 2005, 10:33 AM
|
|
Registered User
|
|
Join Date: May 2005
Location: United States
Posts: 5
Time spent in forums: 2 h 4 m 33 sec
Reputation Power: 0
|
|
Processing Excel Files with VBA
Question:
There is a list in Microsoft Excel that contains various IP addresses in the 5th column from the left (columns 1-4 contain other data). I need to edit this Excel file: I only need certain IP addresses out of ALL the others, thereby deleting the extraneous addresses.
Does VBA have a function that will actually go through the Excel file and *HIGHLIGHT* the addresses in Column 5 that I don't need? If there is, what is this function? Thanks!
|