Use autofill in vba to get the last row (run time error)

[Chaos00]

HI Experts,

I'm hoping to select cells A3:B3 and fill to the last row. Column C has data in it, but the last row varies for the count. The below code is my attempt at trying to get this to work, but I end up with a runtime error 1004.

Please Login or Register  to view this content.

Thankyou.

[WasWodge]

Try...

Please Login or Register  to view this content.

although there is no point using a with statement with the activesheet so just...

Please Login or Register  to view this content.

For both codes
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

if you mean column C is your longest column with data.

in your statement

Column C has data in it, but the last row varies for the count

[Chaos00]

thanks for the advice and response.

[Chaos00]

Yes, column c has the longest column with data. I'll give these suggestions a try. thank you.

[Chaos00]

Thank you for the response. apologies for the very tardy reply here. your suggestions were helpful so thankyou.