Posted to microsoft.public.excel.programming

Martin Stabb Martin Stabb is offline

external usenet poster

Posts: 2

Sub routine failure

The following subroutine works fine in a blank sheet but
only the first line works in my calculation sheet in the
same workbook. Any ideas please?

Sub ResetDefaults()

Cells(12, 4).Formula = "=20"
Cells(15, 4).Formula = "=250"
Cells(21, 4).Formula = "=PI()*D20^2/4"
Cells(16, 12).Formula = "=D13/D14"
Cells(17, 12).Formula = "=D13/D21"

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sub routine	Gord Dibben	Excel Discussion (Misc queries)	0	November 13th 09 12:15 AM
vlookup failure & ctrl-f failure?	joemeshuggah	Excel Discussion (Misc queries)	4	December 22nd 08 07:22 PM
SUB ROUTINE	tokirk	Excel Programming	1	January 19th 04 02:17 AM
Routine??	Zax	Excel Programming	3	December 19th 03 05:50 PM
Need VBA Routine	John M. Lembo	Excel Programming	0	July 13th 03 01:51 AM

All times are GMT +1. The time now is 12:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us