I would like to use "Range("G" & Rows.Count).End(xlUp)" to determine the last used cell in Range("G"), and select it AND its "Offset(1,0)". I am running into issues when pairing it with the Autofill code from Macro Recorder. See below:
What I need to do (This is only an example, and does not use the method shown above):
Range("L2").Select
Selection.AutoFill Destination:=Range("L2:L450"), Type:=xlFillDefault
Range("L2:L450").Select
BUT, I am having issues pairing the method which selects the last used cell AND it's row offset of 1. I.E. see below:
Range("G" & Rows.Count).End(xlUp).Select
Selection.AutoFill Destination:='Issues here, Type:=xlFillDefault
'Issues here
What I need to do (This is only an example, and does not use the method shown above):
Range("L2").Select
Selection.AutoFill Destination:=Range("L2:L450"), Type:=xlFillDefault
Range("L2:L450").Select
BUT, I am having issues pairing the method which selects the last used cell AND it's row offset of 1. I.E. see below:
Range("G" & Rows.Count).End(xlUp).Select
Selection.AutoFill Destination:='Issues here, Type:=xlFillDefault
'Issues here