View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default When you select a range with a macro

DIM Cell as Range

SET Cell = Range("B65000").End(xlUp).Offset(0,-1)


Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
Hello,

When you select a range with a macro, via End xldown

etc... I would like to
select this range minus 1 column, how is this possbiel

in excell

Regards

Patrick


.