How do I create a macro to copy a dynamic range?

[Student1990]

I am a beginner as far as VBA goes, and I appreciate everyone's help.

I need to create a macro to copy a range from one worksheet to another within the same work book. However, the range that I need to copy can change daily. The range will always be in column A; however, on a day-to-day basis, the data might extend from as few as 200 rows to as many as 1000+ rows. I need to come up with a way for Excel to copy from A1 until it recognizes that the data has stopped (copy from A1 until the very last non-blank cell in column A).

Does anyone have any insight? Thank you very much for taking the time to read my question.

[AB33]

Please Login or Register  to view this content.

[Student1990]

Thank you very much for your help!

[HaHoBe]

Hi, Student1990,

Please Login or Register  to view this content.

Ciao,
Holger

[Student1990]

Thank you, Holger.

Both answers on here are helpful to me.