Thread: sorting in a macro and defining last row into varible not working in
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NOPIK NOPIK is offline
external usenet poster
  
Posts: 50
Default sorting in a macro and defining last row into varible not working
You pass Long as argument to Range.
May be, you should redefine LastRow99, and use End(xlUp).EntireRow
range
Reply With QuoteReply With Quote