C Charles Jan 8, 2004 #1 Hi Can someone help I am trying to find the first cell in a range any help will be much appreciated thanks 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 Jan 8, 2004 #2 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
B Bob Phillips Jan 8, 2004 #3 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)
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 Jan 8, 2004 #4 use this syntax:- MyRange.Range("A1") Patrick Molloy Microsoft Excel MVP
