LinkBack URL
About LinkBacks
Can someone help me to reconstruct my code or make it more simpler?
Please Login or Register to view this content.
Can someone help me to reconstruct my code or make it more simpler?
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Yey! It works.Thanks yudlugar.
I have a question. But why, when I run this macro[dataTableChanger] and run another macro[......] the speed process become slow.
P.S. -> Another Macro like importing data for short [COPY/PASTE] in the TABLE.
Thought I would add that in your initial declarations, you set forth:which I'm guessing you assumed meant that both would be dimensioned as Single. In VBA, you must declare each explicitly, else the variable takes on the default Variant type. So what you actually declared was:Please Login or Register to view this content.
Hope this helpsPlease Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
AlvaroSiza, thank you for your giving me a guide how to declare a variable. Yes, I declare it both Single but now I will change it from what you have taught me.Originally Posted by AlvaroSiza
Thought I would add that in your initial declarations, you set forth:which I'm guessing you assumed meant that both would be dimensioned as Single. In VBA, you must declare each explicitly, else the variable takes on the default Variant type. So what you actually declared was:Please Login or Register to view this content.
Hope this helpsPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks