Consulting

Results 1 to 4 of 4

Thread: Create a Const that references a Range

  1. 08-16-2010, 03:28 AM #1
    samkhalilian
    samkhalilian is offline
    VBAX Newbie
    Joined
    Feb 2009
    Posts
    4
    Location

    Create a Const that references a Range

    Hi,

    Is it possible to create a Const that references a Range i.e.

    Public Const MyConst As Range = Range("A1")

    Cheers, Sam
    Reply With Quote Reply With Quote
  2. 08-16-2010, 03:48 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    No.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 08-16-2010, 03:51 AM #3
    samkhalilian
    samkhalilian is offline
    VBAX Newbie
    Joined
    Feb 2009
    Posts
    4
    Location
    why?
    Reply With Quote Reply With Quote
  4. 08-16-2010, 04:30 AM #4
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try it and see.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules