Changing Columns Reference Code??

[stephen.smith]

Hey guys
I am trying to change a cell reference using VBA. The reference has the column with $ before hand so, $B and I am trying to use code to change this to any other column example $K on many different cells at one time. I have tried a replace code but its not working because of the $ I think. I need to keep the $ in the reference, so is there a way to do this. Any help would be really appreciated. Below is an example of what i have tried.
Thanks
Stephen

Code:

Sub test()
On Error Resume Next
Dim c As String, d As String
c = InputBox("Enter Original Column Letter")
d = InputBox("Enter New Column Letter")
Range("A1:A100").Replace "$" & c, "$" & d
End Sub

 

[stephen.smith]

That's great. Thanks so much, I'm new to all this so very sorry if this was a basic error. The help was greatly appreciated!

 

[stephen.smith]

Hi
I Have since tried changing the range to the cell path suggested, however this again does not work. The range I tried is pasted below. This is where the cell is referenced to find the values I am looking for. Can anyone please help.

='P:\IPS 201112\[Week By Week Risk Management Info.xlsx]Game Rate'!B100:J399