-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
pain
-
E
Tracing Formula Frustrations — due to complex cell referencing
Suffering some apparent limitations of Excel. Excel cell referencing (i.e. $A$6) can become a major pain when I have to make changes to a complex spreadsheet. Multiple formulas to update etc. Tracing the formula is a major pain! I.e. Vlookup(A3, ProductMaster!$A$1:$D$25, 3, false) verses...- excelspark
- Thread
- formula pain reference cell tracing vlookup
- Replies: 1
- Forum: Excel Questions
-
J
Writing formulas with VBA better methods?
Hi, I have a report which is generated with VBA referencing data from another sheet with formulas then turned into values Example Range("D2:D1000").FormulaR1C1 = "=R[-1]C[-1]*10" Range("D2:D1000").value = Range("D2:D1000").value Which works fine but the problem is if I ever need to modify...- JumboCactuar
- Thread
- formulas modify pain ranged2d1000.value vba
- Replies: 6
- Forum: Excel Questions
-
G
Multiple measures on a line chart?
Is there a straightforward way to do this? Clearly I could union two tables together, but that seems a massive pain. I just want to drag two measures into the value area of a line chart!- gazpage
- Thread
- chart line massive measures pain
- Replies: 0
- Forum: Power Tools
-
T
More elegant way
Hi. I want Excel to execute the following...- Tasss
- Thread
- elegant enter lot pain shorten formula
- Replies: 2
- Forum: Excel Questions
