[AccessD] A couple of Excel questions

Hi Arthur,

I couldn't duplicate your #1 issue - what steps are you going through to
change column width?

On #2 I have to pass!

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, August 24, 2007 9:10 AM
To: Access Developers discussion and problem solving; Discussion of Hardware
and Software issues
Subject: [AccessD] A couple of Excel questions

Forgive the double-post. I wasn't sure whether this belongs on dba-Tech or
if it's ok here.


1. When I change column widths on one sheet, it seems to change them on all
sheets. Can't I affect only one sheet?
2. On one of my sheets there is a column that does a VLOOKUP() into another
sheet. Except for the relative row number of the lookup value, the formulae
are identical down the column. But two lookups fail. There doesn't seem to
be anything different about these two. In one case the lookup value is 4431
and the other 11503. I tried switching them to strings and ditto in lookup
table, to no avail. Any idea why these two, and only these two out of about
80 lookups, fail?

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com