Refer to Group of cells in Excel 2007 using R1C1

  Desert Andy 11:16 19 Feb 10
Locked

Hi

I am trying to write code to refer to a selectin of cells in a column sothat i can copy and paste them to another worksheet. Is it possible to refer to the cells using the R1C1 reference system. The reason for this is that i need to find out which column to copy the data from, and using numbers is much easier. Thanks

  VoG II 11:42 19 Feb 10

Instead of Range("A2:D5") you can use

Range(Cells(2, 1), Cells(5, 4))

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…