lrsp

The following code adds a new item to a list but changes the structure of the list. The current list is (1 - John, 2 - Mary, 3 - Frank and so on, till 200. If I add an item to the list, the code sorts my list by all the 1's and then all the 2's and so on. I want to add 201 - Jim and have him at...

Hi, I have a worksheet which has a button for users to press to add a new line underneath the active cell It copies the existing row and pastes underneath after asking for permission I need to clear the contents from column B and C on the new row only Specific cell references can't be used as...

Hi all, I have a worksheet with a macro button for user to add a new line I currently have a code which will ask for permission to add a new line below the active cell, if confirmed it will copy the existing row and past underneath What I'd like to do is to clear contents from 2 cells in this...