+ Reply to Thread
Results 1 to 1 of 1

Method 'Range' of object'_Global' failed

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Latvia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Method 'Range' of object'_Global' failed

    Hi. I searched forum and internet in general for this topic and people seems to have same problems when trying to .Select something. My situation is different and I whould appreciate any help.
    So here is the part of the code (user form button action) and the red row is where Error is popping out.
    Please Login or Register  to view this content.
    Here are the cotents of ActiveWorkbook.Sheets("wqelmhakimaflnkgb").Cells(3, 2):
    'Mr Kardinal'!$D$5
    Here I should point out that Cells(2, 2), Cells(1,2) contents are $A$5 and $B$5

    The thing I don't understand is: Everything works as it should when I write like this:
    Please Login or Register  to view this content.
    And when debuging code with error, Watch for "ActiveWorkbook.Sheets("wqelmhakimaflnkgb").Cells(3, 2).Value" gives Type:Variant/String and Value:"'Mr Kardinal'!$D$5"
    Please help me! (
    Last edited by arbulgazar; 03-06-2013 at 09:20 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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