More on Macros - Excel 97

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

I realize that I also need to be able to refer in relative terms to the
workbook next to the current workbook.. So what I need to is to cut and
paste the value of a cell from a workbook to the left of the current one
into the current cell. i.e. cut and paste from workbook B into workbook A
using relativity so to speak. I want to use the macro for a number of
paired work books in the spread sheet. Work book B is always to the left
of Work book A.

Any help would be much appreciated!

Abay
 
Yes, mixed work books and work sheets up in my post .. apologies, really am
a newbie .. abay
 
I assume by workbook you mean worksheet

activesheet.previous.Range("A1").Copy Destination:=ActiveCell
 
Back
Top