I'm trying to link a cell to another cell via code. I'm using the following line to do this (WBSSummary is a sheet, intStart and intMachine are integer variables):
WBSSummary.Range("B" & intStart) = "='Project Information'!$B$" & intMachine
If the value in the cell on the Project Information sheet was "P15", I would get "P15" on the WBSSummary sheet. Now i get ='Project Information'!$B$13, not the value of the cell.
I have no clue what happened to change this.
Can anyone help?
WBSSummary.Range("B" & intStart) = "='Project Information'!$B$" & intMachine
If the value in the cell on the Project Information sheet was "P15", I would get "P15" on the WBSSummary sheet. Now i get ='Project Information'!$B$13, not the value of the cell.
I have no clue what happened to change this.
Can anyone help?