Cell Address help
 

Hi,

when I use
Cells(row, col).Address I get something like $B$7 etc. How to get rid of
the $ signs ? Thanks in advance

Srikanth


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Cell Address help
 

Cells(row, col).Address(False,False)

--

HTH

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

"Srikanth Ganesan" wrote in message
...

Hi,

when I use
Cells(row, col).Address I get something like $B$7 etc. How to get rid of
the $ signs ? Thanks in advance

Srikanth


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!