Macro to select a range with blanks in between

[rajkumarmp]

Hi champs,

I need a macro to copy a range with blanks inbetween (no conditional formatting).

ex: if i have A1 to A15 active cells with A2, A5 blanks, the macro should select and copy entire A1 to A15

please help me on this.