View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Correct coding entry of VBA macros in Excel worksheet

If your code uses a Selection range, then you will need to select it each
time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack R" wrote in message
...
Bob: Thanks, will give both options a try. Also if I want a range of

cells
to be RT [running total] active, will the macros do so anytime I open the
worksheet? Or must I select all the cells and do something else?
Gracias!
--
WJR


"Bob Phillips" wrote:

In the VBIDE window (Ctrl-G), just type the macro names and return, or
select them from the Excel app via Alt-F8, and select and run from the
list.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack R" wrote in message
...
It has been some years since I needed this application. On an Excel
spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros

which
will activate a "running total" in each cell. I have the code, but

not
sure
how to enter [type] in the Editor page.
--
WJR