Forum Discussion
Insert variables into an Excel document
Suppose that I inserted some formulas in the excels cells using as input the cells names, as for example: Cells(1,1)= A2*B2 and also Cells(2,1)= A2/B2 In a second time I decided to assign a name t...
Since you mention 'Cells' which I associate with Ranges in VBA (Macros), there is the method equivalent to Jan Karel's user interface command:
Cells.ApplyNames
That can take a number of parameters to specify which names are applied and in what circumstances.