Greetings,

Currently I am trying to create a module that would allow users to
specify the range of rows for a chart that uses the results of a
formula.
When using the module the user types numbers into two textboxes the 1.
starting row in sheet1 and 2. the ending row in sheet1.
These numbers should then be implemented in the formula in sheet two to
calculate the sum between the specified rows.
The formula is as follows:

=SUM(Database!E1134:E1207)

where E1134 should be changed to the first entry in the modules textbox
(i.e. E2054) and E1207 to the second entry.

I tried to use something like:

worksheets("sheet2").Range("M25").Formula =
"=sum(database!E"&x&":E"&y&")"

where x and y represent the textbox values. VBA unfortunately does not
understand this command. Any suggestions?

Marco.


--
mpot4
------------------------------------------------------------------------
mpot4's Profile: http://www.excelforum.com/member.php...o&userid=27418
View this thread: http://www.excelforum.com/showthread...hreadid=469343