I have the following macro that inserts a new column and pastes SLS into
the new column. The way the macro is currently set is to paste it into
rows 2-33.
I need it to paste SLS into all rows in Column G that are not blank
(this can vary from 1 to 500 rows).
Here's the current macro. I'd appreciate any advice
Thanks!
Columns("C:C").Select
Selection.Insert Shift:=xlToRight
Range("C1").Select
ActiveCell.FormulaR1C1 = "SLS"
Range("C1").Select
Selection.Copy
Range("C2:C33").Select
ActiveSheet.Paste
--
TimmerSuds
------------------------------------------------------------------------
TimmerSuds's Profile:
http://www.excelforum.com/member.php...o&userid=35596
View this thread:
http://www.excelforum.com/showthread...hreadid=553818