Tag Archives: Cells

Making Sense Of Cells Intellisense – Part 2

I’m going to follow on from my last post by demonstrating a VBA IDE Intellisense bug when using the Cells property. In my earlier post I used the Worksheet.Cells property but here I’m going to use Range.Cells to avoid Out of Memory … Continue reading


Posted in Microsoft Excel | Tagged , , , , , | 1 Comment

Making Sense of Cells Intellisense – Part 1

A friend of mine asked me a good question today: Why is it that when I type Cells. into the VBA IDE I get Intellisense whereas when I type something like Cells(1). or Cells(1,1). I don’t? Being a strong VBA programmer … Continue reading

Posted in Microsoft Excel | Tagged , , , , , | 5 Comments