Is there a shorter / more direct way to do this?
VB Code:
Sub TestSub() 'TestCell is the name of a specific 'cell containing input data x = ThisWorkbook.Names("TestCell") y = Range(x).Value Cells(12,9).Value = y*y End Sub
|
Results 1 to 9 of 9
Threaded View
|
Click Here to Expand Forum to Full Width |