software

I have written a macro that opens a number of workbooks from a network drive
using Excel. I would like this macro to be used by a number of users. However

I am trying to show different pictures based on a value of a cell. So, if the
value is 1, it shows picture 1; if the value is 2, it shows picture 2, etc.

I have a user with only one arm, and she needs to be able to group worksheets
in Excel. I know that you can right-click a sheet tab and choose quot;Select all

hi can any one help me in creating a chart with 2 diff. y axis scales
like 0 to 1000 and 0 to 0.001 but x axis being the same or vice versa

I am creating an external data query in excel to reterive data from a SQL
database, one of the fields in the db is a date. When I run the query I want

Anybody with assistance please.

I'm trying to get the cell address, not the contents, of a cell referenced
using VLOOKUP. I've tried '=CELL(quot;addressquot;, VLOOKUP(5,Table,2,false)', but

I have several errors that occurs in both excel 2000 and excel 2003

I want to be able to edit records in the source database that are returned to my excel spreadsheet from an access database using MSQuery. While in the the MSQuery window I can choose under records allow edit, I then can edit my records. Once I return the query to excel I lose that functionality. Is there a way to edit records using MSQuery?

I've working with two different sheets in the same workbook. The first

I have a spreadsheet with 4660 rows and AutoComplete does not pick up
anything before row 4007.

Dear All,

is there a formula to remove all blank rows in a sheet all at once

Hi

I am using the following formula

Looking for good resources (books, websites, etc) to learn VBA.

Hi

I would like to creat a product DATABASE that contains prices and JPEG
images. I currentlt have OFFICE PRO 2003. I was wondering what steps can be

how do i alphabetize a range of worksheets? i want to put worksheets of names
in alphabetical order.

I have created a histogram and would like to label the bin range with number
ranges, e.g. 0-4, 5-9, 10-14, 15-19 etc. This works fine for 0-4 and 15-19