Hi,

I have a worksheet which I am populating with graphics...I want to detect
when I am say 10 rows from the top of the chart so I can rescale; I know
there is a rows property and one can have rows(1) or some such but how would
I code that I want to detect what row number I am from the top, anyone know,
thanks for your help, regards, Mark

The TopLeftCell property of the object:

Sub PixRow()
Dim PixRw As Long

PixRw = Sheet1.Pictures(1).TopLeftCell.Row
End Sub

Mike F
"Mark Stephens" wrote in message
...
Hi,

I have a worksheet which I am populating with graphics...I want to detect
when I am say 10 rows from the top of the chart so I can rescale; I know
there is a rows property and one can have rows(1) or some such but how
would I code that I want to detect what row number I am from the top,
anyone know, thanks for your help, regards, Mark

Thanks Mike, much appreciated, kind regards, Mark

"Mike Fogleman" wrote in message
. ..
The TopLeftCell property of the object:

Sub PixRow()
Dim PixRw As Long

PixRw = Sheet1.Pictures(1).TopLeftCell.Row
End Sub

Mike F
"Mark Stephens" wrote in message
...
Hi,

I have a worksheet which I am populating with graphics...I want to detect
when I am say 10 rows from the top of the chart so I can rescale; I know
there is a rows property and one can have rows(1) or some such but how
would I code that I want to detect what row number I am from the top,
anyone know, thanks for your help, regards, Mark