Hi,
I'm fairly new to VBA so please bare with me. I've basically created this macro which print screens and saves the file into pdf looking up which sheet and range in a tab that i created. I'm however getting this compile error with the "Sub test()" turning yellow:
Any ideas?
Please Login or Register to view this content.
Last edited by shiser; 05-22-2014 at 09:19 AM.
Sheet35 is a variable you did not declare what is in it.
Do you means Sheets("Sheet35") or Sheets(35)?
Used in that fashion, Sheet35 must be the CodeName of a sheet, which is what appears to the left of the sheet name in the Project Explorer window. In a new workbook with two sheets, you would see
Sheet1 (Sheet1)
Sheet2 (Sheet2)
Change the name of Sheet1 to Bob, and you'd see
Sheet1 (Bob)
Sheet2 (Sheet2)
After doing that, you could refer to the first sheet as either Sheet1, or Worksheets(1), or Worksheets("Bob")
Last edited by shg; 05-21-2014 at 01:02 PM.
Entia non sunt multiplicanda sine necessitate
I've called the worksheet "test" and I'm getting the same error. I've adjusted it as:
I've also tried:Please Login or Register to view this content.
which I believe is the same thing. I still get the same error annoyinglyPlease Login or Register to view this content.
The first line should never generate a compile error; it would generate a runtime (subscript) error if there is no worksheet named test in the active workbook.Originally Posted by shiser
I've called the worksheet "test" and I'm getting the same error. I've adjusted it as:
I've also tried:Please Login or Register to view this content.
which I believe is the same thing. I still get the same error annoyinglyPlease Login or Register to view this content.
The second line is missing a closing quote after test.
Last edited by shg; 05-22-2014 at 04:17 PM.
I'm confused then because I'm getting a compile error.
The second code was written in heist on the forum but I've had the correct formula in the macro.
Wouldn't the worksheet part of the code turn yellow if that was the issue? Just to clarify, the "Sub test()" is getting the error and turning yellow.
I think I know what the problem is! Its this code:
Basically, what I want it to do is look up the sheet dependent on what I have in my tab.:Please Login or Register to view this content.
and the lookup cell contains for example:Please Login or Register to view this content.
Which is located in cell C4. With my Macro stating i = 4 and sTab location being (i, 3), it should be picking up the correct cell I think.Please Login or Register to view this content.
Do you mean:
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
"subscript out of range"
So close to figuring this out!
That means sTab does not contain the tab name of one of your worksheets.
This worked. I mistakenly had quotations in this line. Thanks!Do you mean:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks