Inserting number of rows based on a count of data

Hi,

I have a list of data in column A that changes length. I'm looking for a macro that can insert columns from column O based on twice the count of data in column A.

eg. if there are 5 entries in Column A, I'd like to insert 10 columns from O. I have the macro to insert columns but it needs an exact number.

Please Login or Register  to view this content.

Any help would be great.

Thanks.

Hi Ranelagh,

It looks like you need some code to count the number of rows in column A.

I use the following to do that

Please Login or Register  to view this content.

Then you might be able to do this in your code.

Please Login or Register  to view this content.

Hope that helps.

Look at http://answers.microsoft.com/en-us/o...c-f38bb66afcaa or search for Rows.Count and LastRow on the net for more examples.