| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find last record in macro and delete all after
I need to find out how to design a macro to find the last record in the
report and delete each row after that last record. Can anybody help please???? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find last record in macro and delete all after
Could you clarify? If you reach the last record, would that not be the last
row? Or is there extraneous data thereafter that is not part of the report? If the latter is true, then how would I know how to recognize which data is part of the report and which is not? I would need to know that so I could tell the program how to tell the difference. "Sherife" wrote: I need to find out how to design a macro to find the last record in the report and delete each row after that last record. Can anybody help please???? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find last record in macro and delete all after
there is added information so that if there are more records on a month to
month basis, the information is there to meet those needs but I delete each record there after the last dated transaction "JLGWhiz" wrote: Could you clarify? If you reach the last record, would that not be the last row? Or is there extraneous data thereafter that is not part of the report? If the latter is true, then how would I know how to recognize which data is part of the report and which is not? I would need to know that so I could tell the program how to tell the difference. "Sherife" wrote: I need to find out how to design a macro to find the last record in the report and delete each row after that last record. Can anybody help please???? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find last record in macro and delete all after
See a possible answer in Programming.
It would be useful not to multipost to multiple groups. Post to all groups at one time so everyone can see when the question has been answered and don't duplicate. -- Regards, Tom Ogilvy "Sherife" wrote in message ... I need to find out how to design a macro to find the last record in the report and delete each row after that last record. Can anybody help please???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to find and delete rows! | Excel Discussion (Misc queries) | |||
| delete pictures with a macro | Excel Discussion (Misc queries) | |||
| Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
| Macro data selection line delete | Excel Discussion (Misc queries) | |||
| Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
Linear Mode
