Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VBA excel sum moving range
Name: stevebriz Date: January 3, 2006 at 05:30:23 Pacific OS: XP professional CPU/Ram: Pent M
Comment:
Can any one please help me with this. I have a range that I would like to sum but am having trouble with getting it to work. I set up 2 strings where by the first cell of the range is "firstcell1" and the last cell is "lastcell1" I want my total to be mytotal = sum("firstcell1":"lastcell1") can someplease help me with this
Name: wizard-fred Date: January 4, 2006 at 01:44:43 Pacific
Reply:
The contents of the first cell of the range should not be 'firstcell1', but rather labelled or named 'firstcell1'. Similarly the contents of the last cell should not be 'lastcell1', but rather labelled or named 'lastcell1'.
Summary: I have created a macro in excel. I edit (F2), delete some unwanted text, and press enter. What happens is the entire contents of the first (original) cell is "copied" to any other cell in which I exe...
Summary: I'm trying to reference a alue that is stored in a cell. Cell "S1" has the value "J2" stored in it. in VBA I'm using this code: cell = Sheets("Form").Range("S1") Sheets("Archive").Range(cell).Paste bu...
Summary: *********************************************Provide 5 detail algorithms (comments & code) that demonstrate the use of Arrays or Ranges and 5 custom engineering functions that can be called from an ex...
0 
