View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GALLAGHE GALLAGHE is offline
external usenet poster
 
Posts: 1
Default LastColumn used as letter(s) in VBA

I have the following code to determine the last column used which returns a
numeric. Is there a method to translate this alpha using VBA e.g. 33 = "AG"

LastColumn =
ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRang e.Columns.Count).Column

Thanks for any assistance,
Kevin