Assemble a destination_range for auto-filling a formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Assemble a destination_range for auto-filling a formula

11-20-2015, 06:47 AM

Debaser

Windows 7 64bit Assemble a destination_range for auto-filling a formula

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

You need:

Code:

Destination:=Range("K2:K" & your_row_variable_here)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto update in formula/Obtain the name of the cell	Eduardo Care	Word	2	08-26-2015 04:45 PM
Wierd... "cell" started auto filling with data from other cells I double click on. How stop it?!	KerryOn	Excel	2	08-10-2015 08:41 PM
I want to use formula to auto update cells with information	Steve81uk	Excel	15	01-09-2015 12:58 PM
Auto-adjusting Formula (by date)	ShankedS	Excel	2	12-03-2014 03:56 PM
matching data from one work sheet to another, then auto filling missing cell information	timomaha	Excel	1	09-12-2014 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 PM.