Modification to Macro for row to start

[VKS]

Dear Experts,
A member helped me with a code that cuts all the columns after a column and pastes it under the column. So far it works very well then it inserts a column and populates it with Data1, Data2 etc.
My problem is Instead of Data1 & Data2 I would like to see text in row 2 of that column (Which is the real header and row one is blank)
Not too sure if I have expressed correctly or no….

Please Login or Register  to view this content.

[jeffreybrown]

Maybe this is what your asking...

This

Please Login or Register  to view this content.

Sets the first row where the pasting will begin. If you want it to start or row 2 instead of 3 then just change to 2.

Another great way for you to see what is happening, open the VBE and use the F8 key to step through the macro so you can see what is happening and what the variable are doing.

[Palmetto]

Just a point of information. The variables are incorrectly declared, though this won't cause an issue with the code because VBA will interpret the variable type.

In the code below, i, j, k and jmax appear to be type as Long variable. In reality, only imax is explicitly declared as long.
Variable i, j, k, and jmax are seen as Variant types, not Long. Same goes for fn1.

Please Login or Register  to view this content.

Properly declared:

Please Login or Register  to view this content.

Read here: Declaring Variables

[VKS]

Thanks Jeff, I will try F8 option.
Pasting is not an issue here it cuts and pastes fine but my problem is it should pick up row two of the column in the newly inserted column A instead of using Data1, Data2, Data3 etc
Thanks/VKS

[jeffreybrown]

I'm sorry, not so much following. Can you attach a small representative sample with a before and after...

[VKS]

I am sorry Jeff, This is the original thread i had started where i managed to get some help
http://www.excelforum.com/excel-prog...html?p=3066722
Please do let me know if you still want me to create a dummy file since i have my limitations in sharing the original data.
Thanks/VKS

[jeffreybrown]

Hi VKS,

Instead of me trying to decipher what is going on here, a sample file with your exact requirements and a before and after will alleviate and guess work.

[VKS]

Hello Jeff,First of all my apologies for pasting the link. I hope the attached file explains my problem/requirement.
Best Regards/VKS

[mike7952]

See if this will work for you. Instead of putting in C in Range A1 use a numeric value for the column. So for column C use 3.

Please Login or Register  to view this content.

[VKS]

Dear Mike, Thanks for your help... attached please find the error i get using your code.
Best Regards/VKS

[mike7952]

you need to change Before Running the Code to the sheet name that your working with.

Please Login or Register  to view this content.

[VKS]

Hello Mike, You already have my One Star wish i could give you Five for this one.....
Thanks again Mike. THANKS A LOT