macro help

  • Thread starter Thread starter Roy Gudgeon
  • Start date Start date
R

Roy Gudgeon

I am attempting to write a macro that copies and adds 6 columns of
information,that are essentially a blank templete, to the end of data that
already exists in the spreadsheet. Further data is then added to the newly
copied template and saved and a new blank template needs to be added.

The issue i have is that when writing the macro the column number where I
want to paste the new cells will always have old data in that would be over
written.

I want the macro to look for the first blank column and paste the new
template here, is that possible ?

thanks
Roy
 
Hope this helps.

PasteCol =Thisworkbook.Sheets(?).Usedrange.Columns.Count + 1
Thisworkbook.Sheets(?).Cells(1, PasteCol).Paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to create a list 5
VBA - retrieve data on last create named range from previous inserted named range 0
Change Filename in Macro 3
Macro to copy & paste-special-values data to selected worksheets 1
Macro - Copy row base on criteria 3
Copy & Paste Macro 0
Macro: finding a cell on one worksheet and copying to another worksheet 0
Macro repeats and then stops 2

Back
Top