How to read Columns ?

waka · October 23rd, 2009, 03:08 AM

hi,

anyone know how to code to create a new worksheet?
i only manage to read row didn't manage to read column.
i would like to read my sheet1 column5 to 7 and copy it to a new worksheet.

joe1946 · October 23rd, 2009, 04:42 PM

Maybe something like this?

Code:

    Sheets("Sheet1").Columns("E:G").Copy
    Sheets.Add
    ActiveSheet.Paste
    Application.CutCopyMode = False

waka · October 26th, 2009, 02:09 AM

how can i make it, just to copy the value over instead of copying together with the blank space?

Shasur · November 7th, 2009, 10:43 PM

Quote:

Originally Posted by waka

how can i make it, just to copy the value over instead of copying together with the blank space?

Can you try if the following works:

Code:

Sheets("Sheet1").Columns("E:G").UsedRange.Copy

Cheers
Shasur