Thread: Please help me refer to a fixed value.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
funkymonkUK[_189_] funkymonkUK[_189_] is offline
external usenet poster
  
Posts: 1
Default Please help me refer to a fixed value.

Hi

I have a value in workbook which I would like to use a lot of times
without typing in DIM Var as string then Var =
Sheets("Sheet1").range("A1").value in every single sub that I have.

How could I refer to this figure and save time/ my fingers from typing
exactly the same process?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=553325

Reply With QuoteReply With Quote