Quote:
Originally Posted by NoSparks
Sorry, I don't know.
|
Got this one sorted out myself after a sleep and opening a fresh Excel session, which caused a bit of a light bulb moment. It helps when making templates with macros to actually close Excel, and then reopen the template in a clean Excel session so that the template acts as a template.
Quote:
Originally Posted by NoSparks
use a variable equal to the cell value and manipulate the variable rather than the cell.
Something like
Code:
'
L5part = Sheets("Report template - Advanced").Range("L5").Value
L5part = Replace(Replace(L5part, " / ", "/"), "/", "_")
MsgBox L5part
'
|
I have spend the last couple of hours looking and trying to get your code suggestion to work and buried myself in Google searches... I must be missing something obvious because I just can't get it to run.... HELP PLEASE, it IS the last piece of this jigsaw for me