Cell Address help

  • Thread starter Thread starter Srikanth Ganesan
  • Start date Start date
S

Srikanth Ganesan

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminating cells 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Sheet Cleanup Help Please 5
Finding matching cells 4
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Excel spreadsheet to Word document 1
Copying data from Sheet1 which is on multiple rows for each customerto Sheet2 on single row. 2

Back
Top