How to reference cells in VBA

**Jiptastic** · 12-04-2012, 10:11 PM

How can I reference a range using the cells property? I know how to refer to one cell, but not a group. Here's my attempt:

Please Login or Register  to view this content.

my attempt sucks-

**MarvinP** · 12-04-2012, 10:13 PM

How about for A1 to J1 would be:

Please Login or Register  to view this content.

Or
A1 to A10 would be:

Please Login or Register  to view this content.

**Jiptastic** · 12-04-2012, 10:27 PM

Yep. Perfecto!

Re: How to reference cells in VBA