Morning,
Please help me to optimize my code see below.
Actually i have an execution error 1004 at line "Selection.Offset(1, 0).Select"
Please Login or Register to view this content.
Morning,
Please help me to optimize my code see below.
Actually i have an execution error 1004 at line "Selection.Offset(1, 0).Select"
Please Login or Register to view this content.
Last edited by alansidman; 04-30-2019 at 06:52 AM.
Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html
(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Morning,
Thanks you for quick reply.
See below my code with right statement.
Please Login or Register to view this content.
What cell is selected when the error occurs?
Entia non sunt multiplicanda sine necessitate
It's exactly the same question I asked him on another forum (so again a wild cross-posting case !) but his new post did not even answer …
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks