Modify cells macro (1 Viewer)

evanhughes

Registered User.
Local time
Today, 05:23
Joined
Nov 26, 2009
Messages
46
Hi All

I have a macro which deletes line 2 of a csv file and converts all values in existing cells in columns K to AC to a currency format. This works well.

What I need to add is code to check column D and if cell value is "OWO" then modify cells in columns K to AC in same row to 0 (zero).

Any help on code to add to my existing macro would be very appreciated.

Regards

Evan
 

Brianwarnock

Retired
Local time
Today, 05:23
Joined
Jun 2, 2003
Messages
12,701
If you are asking people to modify code it would be useful to post that code,, however it should be simple for you to check col D and set the values in K to AC since you are already setting the format

Brian
 

evanhughes

Registered User.
Local time
Today, 05:23
Joined
Nov 26, 2009
Messages
46
Brian

Thanks for the quick reply.

The code is attached in a text file.

Evan
 

Attachments

  • Code.txt
    1.5 KB · Views: 103

Users who are viewing this thread

Top Bottom