Problem creating a named range
Code looks like this:
ActiveWorkbook.Names.Add Name:=varName, RefersTo:="Sheet!" & varStartCell
Creates a name, which I cannot use, because it is surrounded by quotation "
" symbols.
Note about Varname: is created after stripping out spaces from user entered
input; varStartCell is an absolute reference like $A$5
TY
|