+ Reply to Thread
Results 1 to 4 of 4

Range, Cells and all that

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    26

    Range, Cells and all that

    Hi,

    I am trying to achieve sth. like this:

    Please Login or Register  to view this content.
    The compiler doesn't like it and hands me a "Object variable or With block variable not set (Error 91)". What is the right way to do it? Thanks!

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Range, Cells and all that

    Objects need Set.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Range, Cells and all that

    it should look like this:

    Please Login or Register  to view this content.
    tom1977

    how to delete this post??
    Last edited by tom1977; 10-06-2011 at 03:48 PM.

  4. #4
    Registered User
    Join Date
    10-03-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    26

    Re: Range, Cells and all that

    Thanks! Always forget to 'Set'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1