macro to copy absolute cells, then paste relative

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to record a macro that will copy an absolute group of cells, then
paste relative to the cell that was active before running the macro. Can
anyone help?
Or maybe there is another way to accomplish my goal. I want to be able to
insert a given set of cells in the middle of the document, any number of
times. It is a form to be used over and over, but each time there will be a
different number of these groups of cells in the form.
 
Bill

maybe this will set you off in the right direction:

Range("A1:E9").Copy ActiveCell

Copies the range of cells to wherever the active cell is.

Regards

Trevor
 
You must log in or register to reply here.

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

Need Macro... 8
Create if partial match then copy and paste data from one cell to another 1
Macro that will insert a simple text string in top cell of text file 1
macro copy and paste 3
Macro for checking data in a cell against another cell andcopying/pasting data 8
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Altered pasting functionality 3
Absolute to Relative Referencing 3

Back
Top