Hello there,
I'm looking for VBA code to check entire column A in specific sheet "sheet3" on a specific value "SEC55B". If there is a value change it to "SEC550".
Can somebody help me out please.
Thnx a lot
Aquila
Hello there,
I'm looking for VBA code to check entire column A in specific sheet "sheet3" on a specific value "SEC55B". If there is a value change it to "SEC550".
Can somebody help me out please.
Thnx a lot
Aquila
Last edited by Aquila; 07-08-2010 at 06:50 PM.
Record a macro.
Entia non sunt multiplicanda sine necessitate
Hello shg,
it's not clear to me how to do this by recording a macro
i do record => CNTR+F (the cel is now activated)
then i go to the cell and change the value
this is the code i have in VBA, looks not pretty good to run?
Some words to clear out would be appreciated![]()
Please Login or Register to view this content.
Thnx
Aquila
When I recorded a macro doing that, here's what I got:
... which I would edit to this:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Thnx a lot shg, probably i did something wrong
Aquila
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks