Dymanic Range Starting at a Cell Defined by a Count

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Dymanic Range Starting at a Cell Defined by a Count

12-02-2015, 02:12 AM

Debaser

Windows 7 64bit Dymanic Range Starting at a Cell Defined by a Count

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

Quote:

Originally Posted by Graham Griggs

you should never be using big complicated formulae like this in VBA

Why on earth not? If it's an appropriate formula, why shouldn't you use code to populate the worksheet with it?

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count how many have completed each Training Course within a Date Range	dmcmillion	Excel	3	10-20-2014 09:59 AM
Worksheet defined cell sums	flextera	Excel	3	06-17-2014 11:12 AM
Data validation list filter with range defined by OFFSET	Mango123	Excel	4	03-18-2014 02:52 PM
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err	tinfanide	Excel Programming	2	06-09-2012 10:19 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:00 AM.