Prev: Attempting to schtask for defrag on remote XP computers in dom
Next: Powermt command for several servers (EMC)
From: OldDog on 15 Apr 2010 14:36
Hi,

I am writing a script that will copy certain cells from on sheet to
another. The problem I am having is that the cells I need can appear
in diferent places in the original sheet.

I can copy a range like this:

ws1.Range("C3:C" & row).Copy(ws2.Range("A2"))

However if I try to change the row and column to a variable it does
not work.

I have tried:

ws1.Range(.Cells(rRow & "," & rCol).Cells(row & "," &
rCol)).Copy(ws2.Range("B2"))

And this;

ws1.Range(rRow & "," & rCol & ":" & row & "," &
rCol).Copy(ws2.Range("D2"))

Any ideas?
 | 
Pages: 1
Prev: Attempting to schtask for defrag on remote XP computers in dom
Next: Powermt command for several servers (EMC)