Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default subroutine stops running unexpectedly

I have no clue as to why this is occurring, but when trying to write subroutines and macros and whatnot, my sub stops running when trying to perform some type of cell/range manipulation (.delete, .insert, etc). Does anyone know of some setting or other formatting whatever that may cause this?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default subroutine stops running unexpectedly

I have no clue as to why this is occurring, but when trying to write
subroutines and macros and whatnot, my sub stops running when trying
to perform some type of cell/range manipulation (.delete, .insert,
etc). Does anyone know of some setting or other formatting whatever
that may cause this?


Is Sheet Protection in play? Are you escaping errors with 'On Error
Resume Next'?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default subroutine stops running unexpectedly

not running 'on error resume next'
sheet protection is not in effect. Matter of fact, it executes the .insert or whatever before taking a dive into quits-ville

On Tuesday, September 27, 2016 at 11:03:54 AM UTC-7, GS wrote:
I have no clue as to why this is occurring, but when trying to write
subroutines and macros and whatnot, my sub stops running when trying
to perform some type of cell/range manipulation (.delete, .insert,
etc). Does anyone know of some setting or other formatting whatever
that may cause this?


Is Sheet Protection in play? Are you escaping errors with 'On Error
Resume Next'?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default subroutine stops running unexpectedly

On Tuesday, September 27, 2016 at 11:27:17 AM UTC-7, Matthew Dyer wrote:
not running 'on error resume next'
sheet protection is not in effect. Matter of fact, it executes the .insert or whatever before taking a dive into quits-ville

On Tuesday, September 27, 2016 at 11:03:54 AM UTC-7, GS wrote:
I have no clue as to why this is occurring, but when trying to write
subroutines and macros and whatnot, my sub stops running when trying
to perform some type of cell/range manipulation (.delete, .insert,
etc). Does anyone know of some setting or other formatting whatever
that may cause this?


Is Sheet Protection in play? Are you escaping errors with 'On Error
Resume Next'?

Also tested possible 'compatibility mode' errors, and doesn't run even when exported file is saved as .xlsx
--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default subroutine stops running unexpectedly

not running 'on error resume next'
sheet protection is not in effect. Matter of fact, it executes the
.insert or whatever before taking a dive into quits-ville

On Tuesday, September 27, 2016 at 11:03:54 AM UTC-7, GS wrote:
I have no clue as to why this is occurring, but when trying to
write subroutines and macros and whatnot, my sub stops running
when trying to perform some type of cell/range manipulation
(.delete, .insert, etc). Does anyone know of some setting or other
formatting whatever that may cause this?


Is Sheet Protection in play? Are you escaping errors with 'On Error
Resume Next'?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


Are you specifying the respective 'Shift:=' parameter?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default subroutine stops running unexpectedly

hi,

how have you proceed to delete cells ?

Sub Delete_Rows_example()
'begin to the last and go to the first
'Step -2 -- do it 1 of 2 towards fisrt row
For i = 20 To 1 Step -2
Rows(i).Delete Shift:=xlUp 'back upwards
Next
End Sub

isabelle

Le 2016-09-27 Ã* 13:42, Matthew Dyer a écrit :
I have no clue as to why this is occurring, but when trying to write
subroutines and macros and whatnot, my sub stops running when trying to
perform some type of cell/range manipulation (.delete, .insert, etc). Does
anyone know of some setting or other formatting whatever that may cause
this?

  #7   Report Post  
Banned
 
Posts: 2
Default


Bán hÃ*ng Online Ä‘ang trở nên phÆ°Æ¡ng pháp tiếp thị sản phẩm má»™t cách phổ biến vÃ* hiệu quả. CÆ¡ sở sản xuất bạn Ä‘ang có những sản phẩm mong muốn bán ra thị trÆ°á»ng. NhÆ°ng bạn có quá nhiá»u việc phải lÃ*m! bạn không có nhiá»u thá»i gian dÃ*nh cho việc đăng tin lên những trang web thÆ°Æ¡ng mại Ä‘iện tá»*. Vì váº*y hiệu quả bán hÃ*ng không đạt doanh thu Ä‘á» ra . Tại sao bạn không nghÄ© đến má»™t giải pháp khác mÃ* sản phẩm của bạn vẫn được nhiá»u ngÆ°á»i biết đến má»™t cách rá»™ng rãi trên mạng. Hãy gá»i đến dịch vụ đăng tin quảng cáo nhanh của chúng tôi, dịch vụ đăng tin quảng cáo trên diá»…n Ä‘Ã*n của chúng tôi sẽ lÃ*m phần việc đó để Ä‘Æ°a sản phẩm của bạn lên TOP Google.


GÓI 1
- Chi phÃ* : 800.000 VND / 01 tháng
- Biên soạn nội dung tin đăng.
- 300 tin má»—i ngÃ*y.
- Báo cáo thống kê hÃ*ng ngÃ*y.

GÓI 2
- Chi phÃ* : 1.300.000 VND / 01 tháng
- Biên soạn nội dung tin đăng
- 500 cho tin má»—i ngÃ*y.
- Báo cáo thống kê hÃ*ng ngÃ*y.

GÓI 3
- Chi phÃ* : 1.900.000 VND / 01 tháng
- Biên soạn nội dung tin đăng
- 800 cho tin má»—i ngÃ*y.
- Báo cáo thống kê hÃ*ng ngÃ*y.

GÓI 4
- Chi phÃ* : 3.000.000 VND / 01 tháng
- Biên soạn nội dung tin đăng.
- 1300 tin má»—i ngÃ*y.
- Báo cáo thống kê hÃ*ng ngÃ*y.

GÓI 5
- Chi phÃ* : 4.500.000 VND / 01 tháng
- Biên soạn nội dung tin đăng.
- 2,000 tin má»—i ngÃ*y.
- Báo cáo thống kê hÃ*ng ngÃ*y.

GÓI 6
- Chi phÃ* : 6.500.000 VND / 01 tháng
- Biên soạn nội dung tin đăng
- 3,000 tin má»—i ngÃ*y.
- Báo cáo thống kê hÃ*ng ngÃ*y.

Quý khách hÃ*ng có nhu cầu vui lòng liên hệ:

Mr.TrÃ*: O937 3OO O81

+ Hợp đồng 03 tháng giảm 5%
+ Hợp đồng 06 tháng giảm 10%
+ Hợp đồng 12 tháng giảm 15%


+ Vá»›i má»i gói chúng tôi Ä‘á»u thá»±c hiện đầy đủ má»i chức năng cho quý khách hÃ*ng: Báo cáo đầy đủ ná»™i dung tin cho khách hÃ*ng, thay đổi ná»™i dung vÃ* chá»n website theo yêu cầu của khách hÃ*ng.
+ Phù hợp vá»›i Cá Nhân, Doanh Nghiệp lá»›n nhá» bán sản phẩm hoặc quảng bá thÆ°Æ¡ng hiệu lâu dÃ*i trên Internet.




Nguồn:
dịch vụ đăng tin giá rẻ
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Call A Subroutine on a Sheet Sometimes stops? RJQMAN[_2_] Excel Programming 1 July 12th 10 12:11 AM
Slow Running Subroutine Paul Excel Programming 1 January 17th 10 02:38 AM
Running DDE functions within VBA subroutine - Any assistance appreciated [email protected] Excel Programming 1 April 19th 07 06:08 AM
How to make userform disappear while called subroutine is running Cornelia Excel Programming 2 June 16th 06 10:47 PM
why excel stops running?? usiddiqi Excel Discussion (Misc queries) 2 May 17th 06 10:14 AM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"