-
WSalexanderd
AskWoody Loungerthis is becoming serious an i am greatfull for all the input i agree that using
wsh.Range(“P4”).Formula = _
“=IF(OR(A4=33070,A4=33080,A4=33085,A4=33087,A4=33090,A4=33091,A4=33093,A4=33094,A4=33095,A4=33097,A4=33099,A4=ect ect dose work and at present i have reached a maximum of 29 items but to a slowing down of the end result.
i am now going to split this in half and see if it makes a difference.
Steve Aprahamian reply of 23 july is much quicker but as yet i have not found a way to call up the sub from in the main programe.
still trying to achieve a better product for all to use. -
WSalexanderd
AskWoody Loungeri am sorry i have taken so long to reply to you, but other projects have placed this one on the back burner.
if i use the code as a separate public sub all works ok, what i am having difficulties with now is being able to ” call DeleteBad ” from within my main programme. which unfortunately stops part way through the “Function DeleteMe” at “Ubound” have you any advise on this -
WSalexanderd
AskWoody Loungeri am sorry i have taken so long to reply to you, but other projects have placed this one on the back burner.
if i use the code as a separate public sub all works ok, what i am having difficulties with now is being able to ” call DeleteBad ” from within my main programme. which unfortunately stops part way through the “Function DeleteMe” at “Ubound” have you any advise on this -
WSalexanderd
AskWoody Loungermy greatfull thanks to all who have contributed to answering my cry for help. your suggestion works a treat and the comments made by your self will be acted upon.
for any one who is interested the reason for the program is a fail safe devise. i work for a wholesaler who delivers orders when the value of the order reaches a given value. i try to stop those accounts who fall short by less than 10% from not getting there order delivered. -
WSalexanderd
AskWoody Loungermy greatfull thanks to all who have contributed to answering my cry for help. your suggestion works a treat and the comments made by your self will be acted upon.
for any one who is interested the reason for the program is a fail safe devise. i work for a wholesaler who delivers orders when the value of the order reaches a given value. i try to stop those accounts who fall short by less than 10% from not getting there order delivered. -
WSalexanderd
AskWoody Loungeri have resent the attachment and this time not cut out as much as last time (100K limit)
as you have found out the subtotals which are hilighted in red uses the full range (G4:G1500) before it exits.
i would like it to exit after it finds the last subtotal which could be only 2 or 100 subtotals and could have the last subtotal on row 1000 or on row 50
your patience and help are much appreciated. -
WSalexanderd
AskWoody Loungeri have resent the attachment and this time not cut out as much as last time (100K limit)
as you have found out the subtotals which are hilighted in red uses the full range (G4:G1500) before it exits.
i would like it to exit after it finds the last subtotal which could be only 2 or 100 subtotals and could have the last subtotal on row 1000 or on row 50
your patience and help are much appreciated. -
WSalexanderd
AskWoody Loungermy apologies i tried to save to much ie less than 100k
-
WSalexanderd
AskWoody Loungermy apologies i tried to save to much ie less than 100k
-
WSalexanderd
AskWoody Loungerplease run the first macro( it is quite safe ) takes approx 1 minute to run but is changes the results once i trty to save them
-
WSalexanderd
AskWoody Loungerplease run the first macro( it is quite safe ) takes approx 1 minute to run but is changes the results once i trty to save them
-
WSalexanderd
AskWoody Loungerattached is a zip file with my clumsy macro (which works for me in approx 100 seconds)
-
WSalexanderd
AskWoody Loungerattached is a zip file with my clumsy macro (which works for me in approx 100 seconds)
-
WSalexanderd
AskWoody Loungeronly the subtotals are shown under the alloc column running the macro changes the font to bold
if you prefer i can send an excel file -
WSalexanderd
AskWoody Loungeronly the subtotals are shown under the alloc column running the macro changes the font to bold
if you prefer i can send an excel file
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Windows 11 Insider Preview build 26200.5600 released to DEV
by
joep517
37 minutes ago -
Windows 11 Insider Preview build 26120.3964 (24H2) released to BETA
by
joep517
39 minutes ago -
Drivers suggested via Windows Update
by
Tex265
30 minutes ago -
Thunderbird release notes for 128 esr have disappeared
by
EricB
4 hours, 20 minutes ago -
CISA mutes own website, shifts routine cyber alerts to X, RSS, email
by
Nibbled To Death By Ducks
7 hours, 29 minutes ago -
Apple releases 18.5
by
Susan Bradley
1 hour, 54 minutes ago -
Fedora Linux 40 will go end of life for updates and support on 2025-05-13.
by
Alex5723
8 hours, 55 minutes ago -
How a new type of AI is helping police skirt facial recognition bans
by
Alex5723
9 hours, 33 minutes ago -
Windows 7 ISO /Windows 10 ISO
by
ECWS
16 hours, 29 minutes ago -
No HP software folders
by
fpefpe
17 hours, 14 minutes ago -
Which antivirus apps and VPNs are the most secure in 2025?
by
B. Livingston
1 hour, 11 minutes ago -
Stay connected anywhere
by
Peter Deegan
22 hours, 37 minutes ago -
Copilot, under the table
by
Will Fastie
13 hours, 50 minutes ago -
The Windows experience
by
Will Fastie
1 day, 4 hours ago -
A tale of two operating systems
by
Susan Bradley
19 hours, 47 minutes ago -
Microsoft : Resolving Blue Screen errors in Windows
by
Alex5723
1 day, 10 hours ago -
Where’s the cache today?
by
Up2you2
2 days, 1 hour ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
1 day, 18 hours ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
18 hours, 37 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
55 minutes ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
2 days, 18 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
2 days, 18 hours ago -
regarding april update and may update
by
heybengbeng
2 days, 20 hours ago -
MS Passkey
by
pmruzicka
1 day, 22 hours ago -
Can’t make Opera my default browser
by
bmeacham
3 days, 4 hours ago -
*Some settings are managed by your organization
by
rlowe44
2 days, 14 hours ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
3 days, 2 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
3 days, 22 hours ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
4 days, 7 hours ago -
AI slop
by
Susan Bradley
2 days, 1 hour ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.