Hi All,
I have some VBA code where I'm trying to compare values from sheet1 and sheet2. In my code for sheet1 I have tried,
When I try this I get an error "Subscript out of range". Is it possible what I'm trying to do?
Please Login or Register to view this content.
Thanks in advance.
Last edited by excel_beg_83; 03-28-2011 at 10:36 AM.
Try
Also - Do you have a Sheet2 in your workbook?Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi MarvinP....I'm such an idiot, after reading your post I was looking at the names of my sheets and I had renamed sheet2 but was still referring to it as sheet2. It's working great now.
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks