| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace misc character with previous sheet name
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace misc character with previous sheet name
Application.Caller would probably indicate you are doing this from a User
Defined Function used in a worksheet. If so, a function used that way is not permitted to make changes to the worksheet except to return a value to the cell in which it is located. -- Regards, Tom Ogilvy " wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace new line character | Excel Discussion (Misc queries) | |||
| replace formula references with previous sheet names | Excel Programming | |||
| How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
| How do I replace a character with another? | Excel Discussion (Misc queries) | |||
| How to replace this character ... | Excel Programming | |||
Linear Mode
