Thanks! Don't seem to get it right though. Below is what I've done now in one of my modules, but when I run a procedure in another module with these variables, it says "variable not defined"...
Option Explicit
Public SuperSeason As Variant
Public Season As Variant
Public Brand As Variant
Public Division As Variant
Public FilePath As String
Public TSS As String
Public LSS As String
Public LLSS As String
Public TY As String
Public LY As String
Public LLY As String
Sub LDP()
SuperSeason = Evaluate(ThisWorkbook.Names("SuperSeasonName").Value)
Season = Evaluate(ThisWorkbook.Names("SeasonName").Value)
Brand = Evaluate(ThisWorkbook.Names("BrandName").Value)
Division = Evaluate(ThisWorkbook.Names("DivisionName").Value)
FilePath = "'S:\COMMON-HK2\HK-APAC-MAP\Range Plan\POLO\"
TSS = Left(SuperSeason, 4) & Right(SuperSeason, 2)
LSS = Left(SuperSeason, 4) & Right(SuperSeason, 2) - 1
LLSS = Left(SuperSeason, 4) & Right(SuperSeason, 2) - 2
TY = "SS" & Right(SuperSeason, 2)
LY = "SS" & Right(SuperSeason, 2) - 1
LLY = "SS" & Right(SuperSeason, 2) - 2
Bookmarks