Hi,
Fairly new to this, and was hoping for someone to help/explain to me why im running into this problem.
My problem occur in section " 'Gæld og fremmedkapital "
Please Login or Register to view this content.
It won't find the value (Empty) even tho its there, and just some bonus info if its necessary, all the data is from an external website query
hope you would be kind to help
Best regards
If this is the section you mean then tryPlease Login or Register to view this content.
I have no idea what the statement below means.Please Login or Register to view this content.
It won't find the value (Empty)
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Depending which sheet is active when running the code forgetting the dots before Range could lead to unexpected results.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi Bakerman2
It did the job, and thanks for the advice. Had no idea about the importance of dots before range. thanks
You're welcome.
In a With ... End With structure the dots refer to the Sheet in the structure, otherwise it refers to the ActiveSheet.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks