Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ActiveCell.Copy Range("R3C27")
I thought it should be easy. I'm writing a macro. The first part leads the
Active Cell to a location depending on the value of various (declared) variables. I then want to copy the value in this cell to another cell on the same Worksheet. The line in the title doesn't work nor do nor do various alternatives involving Paste or Select. I always get the dreaded Error 1004 - and the Help button is totally unhelpful. Does anyone know how to copy the contents of the Activecell to another Cell on the same Worksheet? Stuart |