Cell Selection

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys

Below is an example of the problem...

Original code...
Range("A1").Select
Result: Subscript out of range

FIXED code...
Sheets("Renewals WOW 2004").Range("A1").Select

Now why if this sheet was already selected, why did I have
to add the part of the code to specify exactly what sheet
I was talking about. I have used this method hundreds of
times before and it work just fine.

I was running the code from another workbook on another
drive. Im not sure why this would matter because the
sheet was selected. I dont know if that was the reason or
not, but this fixed it.
 
Probably because you put the code in the a worksheet or Thisworkbook
module...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Message - Macro to Unlink MS Queries from Workbook 0
clear all sheets code 4
Array code only works on selected sheet 14
Drawn Objects Q 2
Macro for all Excel Workbooks to print to PDF 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Range(sheet2) = Range(sheet1) 11
Sound repeats unending until closing workbook 2

Back
Top