Reply to thread

Message: [QUOTE="Bob Phillips, post: 6192054"] Create a Public Range variable in a general code module, not ThisWorkbook or a worksheet code module, declaring it before any procedures. Not if you try to use activecell as part of the code, you get a problem. But if you use a base cell you can With Worksheets("FSF") Set grngFSF = .Range(.Cells(5, 1), .Cells(5, 1).SpecialCells(xlLastCell)) End With Note that you still cannot select that range if the sheet is not active, but you shouldn't need to. [/QUOTE]