copy current excel data to a new excel file

[waka]

HI,

anyone know how to copy a specific range of data from current excel to a new excel?

Lets say, range A1:A15, A17:A27, etc.. to a new excel file.

[Evagrius]

Hi - why not try the recorder? It will give the exact code you need and then edit as neccessary.

[waka]

actually i would like to make it automatic. But look at it, i don't think its possible. So i decided to make it semi-auto it, or is it possible to select the range of data and insert it into database MSSQL?

how to code to create a new worksheet? how to read column
i would like to read my sheet1 column 5 to 7 and copy it to a new worksheet.

[royUK]

Waka
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[waka]

Here is my code, i manage to read rows but i couldn't read from columns.

pls guide me along where should i change to make it read from columns. thanks

Please Login or Register  to view this content.

[royUK]

Edit the first post with Code Tags.

[waka]

Edit the first post with Code Tags.

do you mean the "dim something something" i need a code tag?

i already put a code tag on it. thank for reminding me.