Hello,
I have a button in one of my sheets that calls on a Sub in Module1 and the following is the code. I am using variables to set ranges, but I am getting this error. Please assist.
Thanks in advance.
Please Login or Register to view this content.
Which worksheet are DataRangeA and DataRangeB meant to be on?
If posting code please use code tags, see here.
They are meant to be on any of the sheets that the variable "SheetName" dictates.
As it is they'll be on whatever sheet is active when the code is run.
If that's not the sheet named whatever is in SheetName then the code will error.
Range("DataA").Value = B7
I don't understand why I am still getting the error. I'm sure these sheets have a range "B7"....
What sheet is DataA on?
What sheet is active when the code runs?
It is on a completely different sheet, but it is hidden. Could this be the problem?
Nevermind. Problem persists even with the worksheet not hidden.
Can you attach a sample workbook?
I tried running the same code several times and it works half the time and gets the error the half of the time.
The problem is because the ranges in the code have no worksheet references so they will
always refer to the active sheet.
When you run this code DataARange and DataBRange will be referring to ranges on whatever the active sheet is.
The easiest way to fix the problem is to add worksheet references and remove all the unneeded Selects.Please Login or Register to view this content.
Fixed! As you said, I think it was all the unnecessary selects...
Instead of:
Range.Select
Selection.Paste
I did:
Range.Paste
So cleaning up the code helped a lot. Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks