Forum Discussion
VBA - Splitting worksheet by Dept
I do not modified the program but just insert more comment for the changes. Hope you can learn it.
You have to understand the range and cells.
Range("J4") means the cell J4
Range("E" & r_CS &":H" & r_CS) represents the cells from column E to column H in the r_CS-th row.
On the other hand, we may consider cells as well.
Cells(1,2) means the cell in 1st row and 2nd column, i.e. the cell B1
You may also represent it as Cells(1,"B") in case you don't want to count the order of letters.
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've created an Excel file and added two functions to it
Functions other than the standard Excel functions, these functions are in the official language of my country.
These functions are visible in the Visual Basic section that is displayed with EFT and F11.
But now I'm trying to remove these provided functions
Which is registered in this section but the deletion option is inactive in this section I do not modified the program but just insert more comment for the changes. Hope you can learn it.
Man
Thank you for your assistance today. I appreciate it.
How did you learn so much about VBA?
Zia
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.
