Menu

variable paste or fill range

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Sandy

Sandy is offline

external usenet poster

Posts: 156

Default

variable paste or fill range

What is the formula for "BinTest"?

wrote:
Using VBA I need to paste a named formula "BinTest" into a range of
cells in a column. Starting at A37. The length of the range of cells is
dependant upon the value of another name "Range". I want this to
fire when the worksheet is selected if that is possible.

I think I need to use a fill function and somehow check the value of
"Range" and then say fill down from A37 but I have no idea where to
start.

Any help, code examples, etc. will be appreciated

Robert

Reply With Quote

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
How to Copy and Paste a variable range	IK	Excel Programming	1	August 29th 06 09:04 PM
Copy/paste range variable between workbooks	Jim73	Excel Programming	2	January 14th 05 08:17 AM
Fill a listbox with data from variable range	Al	Excel Programming	2	August 10th 04 07:05 AM
Macro to Paste to a Variable Range - HELP	Brandon - Excelinator	Excel Programming	1	August 7th 04 10:04 PM
Paste a Range from a variable	Al[_11_]	Excel Programming	3	October 28th 03 06:04 PM

All times are GMT +1. The time now is 08:06 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement