sheet name

V

venkat1926

Joined
Sep 20, 2009
Messages
47
Reaction score
2
I am fairly conversant with excel vba. But suddenly sometimes I get into fundamental doubts.

please see the entries and results in immediate window

Code: 
?sheets(k).name
 Sheet3
 ?sheets(K).name="sheet3"
 False

why this contradiction? where do I do the mistake?
 

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

How to make the sheet index name same as the sheet name after inserting sheets? 2
Unknown sheet in Project Explorer 4
Convert A1 value to a sheet name and copy to it 2
Filter and copy data to other sheet 3
Auto fill Sheets 1
Delete sheets code error requires object 2
Sheets visible toggle code 3
VBA Code for Pasting Sheets 2

Back
Top