Forum Discussion
VBA - Splitting worksheet by Dept
- Aug 12, 2018
I do not modified the program but just insert more comment for the changes. Hope you can learn it.
Hi Man
Thank you for the reply. I have tried to follow your instructions but I can't get it to work. I have changed the location of the data. Can you have a look and tell me what need to change in order to get this to work again. Please could you add additional comments to the VBA code so I can see what you are changing in order to make the VBA code work.
Thank you in advance.
Zia
I do not modified the program but just insert more comment for the changes. Hope you can learn it.
- Zia SiddiqueAug 12, 2018Copper Contributor
Man
Thank you for your assistance today. I appreciate it.
How did you learn so much about VBA?
Zia
- Man Fai ChanAug 12, 2018Iron Contributor
I have some basic knowledge in computer programming in learning Pascal when I were a student. So that I have concepts on for-loop / while-loop.
For the VBA syntax, I just search the internet for information and then learn it little by little. Another way is to record the macro so that I know some keyword in some operation and then, again, search the internet.
Actually, there is a lot of thing in VBA that I did not know.
- siaparAug 20, 2018Copper ContributorThank you for helping me and for the time that you spent for me