reference new sheet in same workbook

  • Thread starter Thread starter R Doornbosch
  • Start date Start date
R

R Doornbosch

I can't seem to figure out how to calculate information from "sheet5" and
place it on sheet6 starting with

A:1
A:2
A:3 and so on.

Any help with the VBA code I need?
 
I'm not sure what your question is, but perhaps the following
will be useful.

Worksheets("Sheet6").Range("A1").Value = _
Worksheets("Sheet5").Range("A1").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
when I use



Worksheets("Sheet6").Range(A, 1).Value = "My Name"

I get the error "Subject out of range"

I've tried changing "Sheet6" to the sheets name also.
 
Do you have a sheet in your workbook named Sheet6? Also, change

Range(A,1)
to
Range("A1")
or
Cells(1,"A")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top