ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find First Cell In A Range (https://www.excelbanter.com/excel-programming/287199-find-first-cell-range.html)

Charles

Find First Cell In A Range
 
Hi Can someone help I am trying to find the first cell in
a range any help will be much appreciated thanks
Charles

Bob Phillips[_6_]

Find First Cell In A Range
 


--

HTH

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

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




Bob Phillips[_6_]

Find First Cell In A Range
 
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)

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




patrick molloy

Find First Cell In A Range
 
use this syntax:-

MyRange.Range("A1")


Patrick Molloy
Microsoft Excel MVP



-----Original Message-----
Hi Can someone help I am trying to find the first cell

in
a range any help will be much appreciated thanks
Charles
.



All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com