referencing to a cell

[SQUIDD]

Hi all

when using something like this

msgbox(cells(1,1))

can that only work on the active sheet??

lets say on sheet1 in a1 = have "hello"
but im on sheet 2 when i run the code.
can i have it display the word hello with msgbox(cells(1,1))

i know i can use range(blar balr), i have other reasons for this ask?

mainly i want to loop 6 columns and 300 rows

thanks

dave

 

[SQUIDD]

NO PROBLEM

I figured it out

just use WITH

With Sheets("day")
MsgBox (.Cells(5, 5))
End With

 

[Rick Rothstein]

NO PROBLEM

I figured it out

just use WITH

With Sheets("day")
MsgBox (.Cells(5, 5))
End With

You do not actually need the With statement unless you are going to have more rows of data referencing the "day" sheet. If this is the only code line referencing the "day" sheet, then you could do this instead...

MsgBox Sheets("day").Cells(5, 5)

 

[SQUIDD]

Morning Rick

Thats great, thankyou very much, i will amennd code.

spot on

Dave