Varying Range - how will this effect my code?

[geordie_ben]

Apologies in advance for the basic question. I was slowly becoming a whizz at VBA a decade ago, but I'm picking it back up and need a few pointers

I'm making a macro to take info from sheet to another, and then to fill forumula that I've entered into the sheet already (that'll be a separate question to see if I can get the macro to insert the formula for me

The start of my code is:

    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Nominal Products").Select
    Range("B2").Select
    ActiveSheet.Paste
    Range("A2").Select
    Application.CutCopyMode = False
    Selection.AutoFill Destination:=Range("A2:A196")
    Range("A2:A196").Select

The next time I run the macro there may be more or less entries on sheet one. As above my macro states the range as A2:A196 - will this cause me any issues?

 

[geordie_ben]

Ah I was so close when I was trying it! Thank you

Any chance of any pointers on another thread?

https://www.mrexcel.com/forum/excel...s-once-first-set-rows-filled.html#post5066655

 

[MARK858]

Afraid not today as posted on my phone when at work (so amazed that I didn't make any typos )

 

[geordie_ben]

I'm confused by your reply haha

 

[MARK858]

What's confusing? was not by a computer and so only gave an answer to our last question in this post because I could answer the question by writing freehand without testing on my phone.

Can't do that with new threads.

 

[geordie_ben]

Ah! get ya. was too early for my brain to work. **** kids!