View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nathan Bell Nathan Bell is offline
external usenet poster
 
Posts: 7
Default VBA quick help from a newbie

All,

I am trying to determine the code to select the 2 last empty columns in
Excel via VBA. The only code I can find is
Range("IV5").End(xlToLeft).Select the only reason for that is row 5
contains data and 1-4 don't, thus returning results further left than I
wanted when doing a paste.

Again I am trying to select the last 2 empty columns in a worksheet. What
would be the most effective way to do this?

Regards,

Nathan