Formulas in worktabs

Akroyd · May 9th, 2002, 04:40 AM

Is it possible to put a formula in a worksheet tab?

i.e I have a list of deals and want to count them and put the result in the worktab.

Can this be done?

philR · May 9th, 2002, 05:07 AM

Not without at least dipping into visual basic. If you are a reluctant vb user, then do your formula on the spreadsheet and store the result in, say, cell B2. The single line of vb needed would then be something like:
sheets(1).name=sheets(1).range("B2").value

you could then run this macro from a button on the worksheet, from a toolbar or key, or using an event such as the change event. Depends what you want, really.
Hope this helps

[ This Message was edited by: philR on 2002-05-09 04:09 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 04:40 AM	#1
Akroyd New Member Join Date: Mar 2002 Location: Horley Surrey England Posts: 7	Is it possible to put a formula in a worksheet tab? i.e I have a list of deals and want to count them and put the result in the worktab. Can this be done?

May 9th, 2002, 05:07 AM	#2
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	Not without at least dipping into visual basic. If you are a reluctant vb user, then do your formula on the spreadsheet and store the result in, say, cell B2. The single line of vb needed would then be something like: sheets(1).name=sheets(1).range("B2").value you could then run this macro from a button on the worksheet, from a toolbar or key, or using an event such as the change event. Depends what you want, really. Hope this helps [ This Message was edited by: philR on 2002-05-09 04:09 ]