Need to copy values to bottom of column till data runs out

hi, i have data in columns W6:Y6 (w6 has a date in it and x and y have formulas) and want to copy what i have there all the way down to the end of those columns till the data stops. The number of rows of data varies. Sometimes I may have 500 and other times it may be in the thousands of rows. How can I do this in code?

just a clarification. I have data in columns a:w that varies with the extract I do. typically I would do a shft-cntrl-end and then go left 3 columns and shft-up arrow and then cntrl-d

Not sure if this helps, or whether you have those columns populated with data. If it is not populated you would have to rely on another column perhaps A to establish a last row variable.

Please Login or Register  to view this content.

thx. this works for the next row. in those three columns I only have data in row 6 and am trying to copy that down to the last row of data. how do I get that variable to get it to copy to the last column of data?

Maybe:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

thanks! that second method seems to work great since my main data is actually in col b.

You're welcome. Glad to help out and thanks for the feedback.