I was wanting to allow the user to specify a cell or range from an inpu
box on a form. I then wanted to use that information to specify wher
to start an autofill statement.
example
12/1/2003 (user input DATE would be the label)
1/1/2004 (' ' PATTERN ' 'l)
A1 (' ' STARTING CELL ' ')
code...
....
Range(mycell:mycell+1).AutoFill ActiveCell Range(mycell:lastCell)
xlFillFormats And xlFillSeries
....
I basicly want to replace the ...Range(*"A1:B1"*)....with
variable(s).
Thanks for any help..
-----------------------------------------------
~~ Message posted from
http://www.ExcelTip.com
~~View and post usenet messages directly from
http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements