Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Selection VBA code
Hello everyone,
Anyone know vba (excel) that will let me: 1. go to the last cell in the worksheet 2. select that cell 3. delete everything in the cell 4. then select that cell and everything else if A9 is blank 5. delete the selection 6. SUBTOTAL the last row -- This might seem a little confusing, but let me know if I need to be more specific. ** Any help will be greatly appreciated. Have a good day. -- Himansu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Selection VBA code
Himansu,
See comments inline. 1. go to the last cell in the worksheet Define the "last cell in the worksheet" 2. select that cell 3. delete everything in the cell This is fine 4. then select that cell and everything else if A9 is blank Define "everything else" 5. delete the selection 6. SUBTOTAL the last row Why do you want a subtotal on only one row? Cheers, Jason Lepack |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Selection VBA code
Jason,
1. Last cell = ctrl + g | Special | select "Last cell" 4. "everything else" means: If any cell after a9 is blank then go to that cell and select it while selecting the last cell. This will give me a range. 5. Delete that range and subtotal what I select. ** Do you want me to provide you a template or screen shoot? -- Himansu "Jason Lepack" wrote in message ... Himansu, See comments inline. 1. go to the last cell in the worksheet Define the "last cell in the worksheet" 2. select that cell 3. delete everything in the cell This is fine 4. then select that cell and everything else if A9 is blank Define "everything else" 5. delete the selection 6. SUBTOTAL the last row Why do you want a subtotal on only one row? Cheers, Jason Lepack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Selection | Excel Worksheet Functions | |||
Selection Code | Excel Programming | |||
Help with selection code | Excel Programming | |||
Need Code For Selection | Excel Programming | |||
Selection code | Excel Programming |