Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
EntireRow.delete in VBA

at A55:A60000 and now I finish my VBA code and
I would like to delete entire row of some region, for example
Range("A55:A60000").entirerow.select
Selection.entirerow.delete, but it work just clean up the region cells
like the efffect of selection.clearcontents
After the VBA code Selection.entirerow.delete, the rows number from A55:A60000 is
still there in the Excel Sheet that will be problem when saving in as .htm file and its size
of sheets(1) I check is around 30Meg byte. If the entirerow delete is successfule is
supposed Scroll bar of the right side in excel sheet is really long like the one see
in blank sheet in "BOOK1"
Please advise the reason why will be this
Duncan
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r
Suppose it should work, but sometimes, I tried entire.delete is working but sometimes it is not
If using looping, it cost long long VBA running time
For r = 55 To 60000
Rows(r).EntireRow.Delete
Next r