Find and replace macro

[Alphacsulb]

Hello All,

I need some direction in learning how to create a macro. Up until yesterday I didnt know these even existed!!!! Any way, it seems it will be usefull for my business.

Is a macro the right way for me???????? This is what I do:

I have a master invoice for my printing business.

Column A has either X's or O's (In Formula Form).

O represents that something is purchased and I want it to show.
X represents that something is NOT purchased and I want to hide the row.

Right now I use the following steps.
Select Column A - Right Click/Copy/Paste Specia/Values/OK
Edit/Replace/Find O Replace with (nothing)/ Replace All
Select Column A Edit/Goto/Special/Constants/OK
Format /Rows / Hide

Will a macro eliminate these steps????

Help a girl out!

--Christy

[VBA Noob]

Maybe

See link for where to add code

http://www.contextures.com/xlvba01.html#Regular

Amended added an array

Please Login or Register  to view this content.

VBA Noob