Question about SHeet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I usually write Sheet1.*** in vba rather than Sheets("Data").***

This works most of the time, however sometimes the Sheet1. throws an error that says object cannot be found. Why does this work sometimes and not others? To solve it i have to write Sheets("Data")

Thanks in advance
JAmes
 
Hi
probably thoug your sheet 'data' is the first sheet it does not have
the codename 'sheet1'. Have a look in the VBA project explorer if sheet
'data' really has the codename sheet1
 
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

VBA Countif across sheets? 5
range name define on non active(focused) sheet 10
passing a non numeric cell for numeric comparison 2
Code does not error but no copy either 4
Get name of active sheet 2
Excel VBA help: Text file formatting 19
Problem using Range objects 1
4 alternatives to all questions need randomization 1

Back
Top