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 09:33 AM.

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

About Us

"It's about Microsoft Excel"