Quote:
Originally Posted by jt24152
Well. It is doing something but not what i would have hoped.
Currently it runs clear down my list of numbers but it is still only performing the macros of copy pasting from the current sheet (File) to the other sheet (Blank Stickers) in the row of the active cell at which i have selected prior to runs the macros. It doesn't seem to be looking for true/false/blank in column "D". Frustrating.
Any other ideas?
|
Hi,
Is it fine for you to share a sample. As told earlier, there are better ways to perform your task but I provided the solution as per your requirement.
I can look into your code and make necessary corrections and send it back to you.
By the way, you need to run my macro after you have activated the sheet which has column D you are checking for. And I am also assuming that the keyword True is a logical value not a text, i.e. not "TRUE" but TRUE (logical value).
Thanks,
Prashant