Quote:
Originally Posted by jack_n_bub
Hi,
Try this.
Sub CheckForsomething()
Range("D1").Activate
Do While ActiveCell.Value < ""
If ActiveCell.Value = True Then Call Macrotest
ActiveCell.Offset(1, 0).Activate
Loop
End Sub
This code will start from Range D1 and will keep looking in column D until there is either an empty cell or the value of the cell is True.
If the value of cell is true this will call your procedure (macrotest).
Instead of calling the macro you may like to substitute your code in my procedure. Either ways, your purpose should be complete.
Let me know if it helps.
Thanks,
Prashant
|
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?