I'm completely befuddled on what seems like it should be an incredibly easy macro. (Only been working with excel a few days, so please don't hate me because I don't know what Im doing yet.)
I'm getting different worksheets in that I plug in formulas across a few rows and then pull them down to the end of the sheet.
I just cant automate the pulldown part. I'm able to highlight the range I need each time using
Range("H2").Select
Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select
and I think I can save this variable range as a variable using
Dim x As Range Set x = Selection
all of this seems to work until I try to autofill using
x.AutoFill Type:=xlFillDefault
Please help! Any explanation you can give me on line by line code would be greatly appreciated as it helps me understand what the hell I was doing wrong and why as well as whats going on.
(I also know the selection methods Im using are not ideal, but they make sense in my head so its easier for me to work with them and Im not hampered by their lack of efficiency or malleability at this point)
Thanks again!
I'm getting different worksheets in that I plug in formulas across a few rows and then pull them down to the end of the sheet.
I just cant automate the pulldown part. I'm able to highlight the range I need each time using
Range("H2").Select
Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select
and I think I can save this variable range as a variable using
Dim x As Range Set x = Selection
all of this seems to work until I try to autofill using
x.AutoFill Type:=xlFillDefault
Please help! Any explanation you can give me on line by line code would be greatly appreciated as it helps me understand what the hell I was doing wrong and why as well as whats going on.
(I also know the selection methods Im using are not ideal, but they make sense in my head so its easier for me to work with them and Im not hampered by their lack of efficiency or malleability at this point)
Thanks again!