Thread: LastColumn used as letter(s) in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip[_3_] Chip[_3_] is offline
external usenet poster
  
Posts: 133
Default LastColumn used as letter(s) in VBA
I just got this to work:

lastcolumn = Mid(ActiveSheet.UsedRange.Columns.Address, 7, 1)

Reply With QuoteReply With Quote