View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crazybass2 crazybass2 is offline
external usenet poster
 
Posts: 167
Default Select specific columns for a given cell selection

I want to select the first four columns ("A:D") of what ever row the user
selects a cell in, using a "Selection_Change" event.

So if I click cell A4, cells A4:D4 are selected. Likewise, if I click cell
C4, cells A4:D4 are selected. Sure it's an easy script that I've just
overlooked, but could use someone's help.

Thanks,
Mike