T Tom Schroder Nov 3, 2003 #1 How do I use the colum referance in a cell in a formula. Example cell A1= W Formula is +(cell A1 row10-E9)/E9
How do I use the colum referance in a cell in a formula. Example cell A1= W Formula is +(cell A1 row10-E9)/E9
B Bob Phillips Nov 3, 2003 #2 Tom, suggestion, .. use Macro Recorder and type the formula in a cell, and then examine the code. It should help you. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Tom, suggestion, .. use Macro Recorder and type the formula in a cell, and then examine the code. It should help you. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
