View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
np np is offline
external usenet poster
 
Posts: 10
Default Macro to select cells in column enter data then press enter

I need to create a macro and assign it a macro button at the top of the
worksheet (with the text Enter Hours) . This macro needs to select the cells
in Colum E (called Hours) enabling me to enter hours in, pressing Enter after
each figure.

Can someone help me with a formula and how to record this macro?

Thanks in advance.