Thread: i want display the last coloum value in first coloum
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default i want display the last coloum value in first coloum
Try something like

Dim Rng As Range
Set Rng = Cells(Rows.Count, "A").End(xlUp)
MsgBox Rng.Value



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sajid" wrote in message
...
hello sir


Reply With QuoteReply With Quote