Find First Cell In A Range

C

Charles

Hi Can someone help I am trying to find the first cell in
a range any help will be much appreciated thanks
Charles
 
B

Bob Phillips

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

selection.cells(1,1).value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
P

Patrick Molloy

use this syntax:-

MyRange.Range("A1")


Patrick Molloy
Microsoft Excel MVP
 
Top