Dummy Excel
Well-known Member
- Joined
- Sep 21, 2005
- Messages
- 1,004
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi All,
can anyone help me with some VB code on coping a column of data which has blank cells? I don't want to use Range("A:A").copy as this will copy 1,048,576 cells.
thanks in advance
Sam
can anyone help me with some VB code on coping a column of data which has blank cells? I don't want to use Range("A:A").copy as this will copy 1,048,576 cells.
thanks in advance
Sam