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.
Excel cell addresses
Name: Yngin Date: August 25, 2008 at 05:47:49 Pacific OS: XP CPU/Ram: - Product: -
Comment:
I am trying to find a way to use a number from a cell to help specify a cell address.
Example: I have a cell with a number in it, let's call this number x. Now I want to get another number from a cell with the address <Sheet2!Ax>, is this possible?
I've tried different methods with INDIRECT, but it didn't help.
Example 2: Say I want the SUM from cell A1 to cell Ax, where x is a number in another cell that can change independently. Can you write =SUM(A1:A"Sheet2C3") or something similar?
Summary: I am trying to code a carriage return within an excel cell using vbscript. When I append chr(10) or Chr(10) & Chr(13) to the string that is being written in the cell, it begins a new row in the excel ...
Summary: I am trying to assign a user defined VB function to excel cell. I wrote a s simple function called testy() in VB editor that returned a number. Function testy() As Single testy = 2.4 End Function ...
Summary: Is it possible to have it so that Excel cells/rows/sheets can be edited only once? That is, information can be entered, then the spreadsheet saved, but subsequent editing of the previously entered inf...
0 
Default font Word 2002
