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.
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:
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!
(
Bookmarks