Hi,

I want to replace the # character with ='previoussheetname'!

so #D55 becomes ='PreviousSheet'!D55

Does anyone know how (if) I can make this work?

Cells.Replace What:="#",
Replacement:="='"&Application.Caller.Worksheet.Pre vious.Name&"'!",
LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
_
ReplaceFormat:=False


Thanks!
Helen