I am trying to copy a cell formula from one cell to a column that starts at cell G6 but is variable length.
I created a macro and the copy worked but with a variable number of rows, the code created may not work.
So I have no idea how to come up with the formula for the destination in the following code
So I want to be able to copy but down as many rows as may be there. However, I do not know how to determine the range to copy based on what is in column F.
Any help is appreciated.
TIA, rasinc
I created a macro and the copy worked but with a variable number of rows, the code created may not work.
So I have no idea how to come up with the formula for the destination in the following code
Code:
Sheets("Setup").Select
Range("J2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("PriceLists").Select
Range("G6").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("G6:G90") 'here I believe may be the issue
Range("G6:G90").Select
So I want to be able to copy but down as many rows as may be there. However, I do not know how to determine the range to copy based on what is in column F.
Any help is appreciated.
TIA, rasinc