Cell input into formula

=?Utf-8?B?RkFTVFdSWA==?=

Guest

Posts: n/a

14th Jul 2006

Ok...perhaps tough to explain. I'm doing a macro in which the length of the
analyzed document changes. I'm attempting a work around in which the last
row of populated cells is input into a cell. (assume 1000 is entered into A1)

Macro will select the equation: =concatenate("b2:f",a1)

Essentially, this is the key to what I need to figure out how to do. (I'm
not very good with VB)

« Count the number of rows where more than one column meets set crit | Leauge Table....Help!!! »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User input into cell formula?	StargateFan	Microsoft Excel Programming	5	7th Nov 2010 09:54 AM
2003 FORMULA only plz -input in cell, chng & go to cell on otr wks	tlc	Microsoft Excel Worksheet Functions	1	24th Jan 2009 11:47 PM
use information from an input box in cell reference formula	Chas	Microsoft Excel Programming	4	17th Sep 2008 08:19 PM
Change cell formula based on input in different cell	DtTall	Microsoft Excel Programming	4	16th Nov 2006 10:34 AM
Value or formula in cell depending on input...	Jan Jansens	Microsoft Excel Programming	4	6th Sep 2005 08:54 PM