[dba-Tech] Error handling in Excel

Jon Tydda jon at tydda.plus.com
Sun Jul 8 14:58:20 CDT 2007


Way over my head I'm afraid, sorry Susan


Jon

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 08 July 2007 20:43
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Error handling in Excel

I'll give it a try -- I started to and then couldn't find anything in
Excel's VBA Help so thought it just didn't exist in Excel. 

Here's another one that should be simple -- I'm trying to use a range name
-- but it returns an error -- here's what I've tried -- where OrderID is the
named range:

Set rg = Range(OrderID.Address)
Set rg = OrderID.Address
Set rg = OrderID

I want to use rg in the following: 
Range(rg.Address).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range("H1"), Unique:=True
  
When I was using Selection, it worked fine 

Set rg = Selection
'Create unique list
Range(rg.Address).AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("H1"), Unique:=True

-- but I hoped to eliminate user error by naming the source list and using
the named range instead of forcing the user to select the source list. 

Susan H. 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jon Tydda
Sent: Sunday, July 08, 2007 3:28 PM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Error handling in Excel

Should both be the same surely?

You definitely use On Error in Excel, I've got some code (not here though,
helpfully) with it in.


Jon

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 08 July 2007 20:12
To: 'Discussion of Hardware and Software issues'
Subject: [dba-Tech] Error handling in Excel

I don't know the first thing about handling errors in Excel -- I'm looking
for something similar to the On Error statement in Access. 

Susan H. 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

--
This email has been verified as Virus free Virus Protection and more
available at http://www.plus.net

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

Internal Virus Database is out-of-date.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.14/882 - Release Date: 6/30/2007
3:10 PM
 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

--
This email has been verified as Virus free Virus Protection and more
available at http://www.plus.net




More information about the dba-Tech mailing list