Newbie help...VBA w/ Excel
Using Find on a selected column (or other range of cells) is another
effective alternative to literally looping through each cell or record.
--
Bob Kilmer
"Joe" wrote in message
...
Turn on the macro recorder and name your macro.
Select your range of data.
Turn on AutoFilter
Filter on column B for True
Copy
Select your target sheet
Paste.
Then use Tools Macros Visual Basic Editor.
In Module 1 you can find the code generated. There are
ways to loop through the records looking for True, but
they are generally a lot less efficient than the
AutoFilter.
-----Original Message-----
Hi Everybody:
I'm a newbie to the whole VBA thing so I was wondering if
somebody could point me towards the right direction for
this. Basically what I want to do is in a Excel
worksheet I want to check if Column B in page 2 has the
word "True" in it. if it does, I want to copy the whole
row. It doesn't seem hard but i'm not too familar w/
VBA. Could someone help me get started?
.
|