Not Recognizing UsedRange

[freybe06]

Hello Everyone,

I have some code here that looks like its doing everything correctly except at the end when I ask the macro to copy the UsedRange, it returns a blank. I'm not sure why.

Could someone please take a look at this and let me know if there is something I'm missing? Thanks!

Please Login or Register  to view this content.

[ragulduy]

Works fine for me on a quick dummy workbook, I'd suggest uploading a workbook to get a quicker answer as to what is wrong.

[freybe06]

Strange... I closed the workbook so I could make a test one for you, then I opened it back up and ran the same exact code and it worked!

I apologize for taking up your time. Thanks for your help though!

[AB33]

You will experience the same problem again until you change this line

Please Login or Register  to view this content.

Active sheet happens to be where ever your cursor is. Change the active sheet in to sheet name.

[ragulduy]

@AB33,

There is a sheets.add command on the previous line so the activesheet should always be the correct one in this case.

[AB33]

Yes,
But this line

Please Login or Register  to view this content.

will also create another error if you re-run the code as the sheet name already exists.