Question about "autocomplete"

R

Robert Crandal

The following two commands achieve the same result:

1) Sheet13.Cells(7, 6).Value = 1

or

2) Sheet13.Range("F7").Value = 1

If these two commands have the same result, why
does Excel's "autocomplete" feature in the text
editor only work with the second command?

Just curious....

Thanks
 

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

Question about a range 9
non-expanding range, and also a VBA Sort error 7
Code to insert a coma 26
Copy columns by Header and select all data (non-contiguous) from those columns 8
Excel limits question 2
Problem with SET & REF function 0
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
[Q] For, Next - How to Speed Up 6

Top