For Each Worksheet in Workbook - Find Rows that are not Blank and Paste Value

[MICowboy13]

Good Afternoon,

I need some help creating a VBA;

For each worksheet in workbook I need to find the rows that are not blank, and in Column "G" of these rows paste the value that is in Cell "B9" of that same worksheet.


Thank You

[PCI]

"in Column "G" of these rows paste the value that is in Cell "B9""
Whatever the value of cell in column "G" ??

If yes

try

Please Login or Register  to view this content.

[MICowboy13]

Thanks for the help!

[TMS]

Neat solution. Misread the question and was beaten to the draw

(thought it had to go in blank rows. Ho, hum.)

Regards, TMS