I get a report from Dell OMSA that list all my dell servers and the hardware
and firmware versions. The report lists each server in a row with its
attributes to the right. So far, so good. If the server has multiple NIC's it
will create a row for each NIC. So I can have multiple ...

I am having trouble with an automation project that I am working on. I
am generating a report in a spreadsheet. Originally I attempted to do
it in Access, but it did not provide me enough flexibility to
accomplish what I was looking to do. The report is an old report that

I'm almost done writing a little "LegalWorkSheet()" function that accepts the
proposed worksheet name and returns a version of it that's guaranteed not to
trap out when assigned to a worksheet.
One thing I haven't done yet is to iterate through all existing sheets to see if

OK, the subject should say a lot about my Excel programming experience.
I'm quite the flaming novice. :)
I'm trying to change the text in a sheet named "Cert" on a cell
starting in column C to the text in a cell in another sheet in the same

I have a vb6 program where I merge vba script(that handles formatting)
with an existing excel file.  If i turn 'visible' on and manually save
the excel file and re-open it, the formatting is correct.  If I merge
the vba script with the excel file and save through code(visible =

I've a Excel sheet with customer name and the contract end date.wht i'm
looking for is i want to get a alert message whn open the workbook 1 week
before the contract end date.

For viewing purposes, I frequently hide all the columns that exceed
what a single page would print so that I can focus only on what I know
is the actual page.  In doing so, the worksheet hugs the left side of
the screen with everything to the right of the page in grey--about half

I'm completely new to VB and excel but I need a macro that does the
following, just to give you the background its a picking list that
lists our entire product range but to cut down on wasted paper and
picking errors we only want to display and print items that are

Is there a macro that will a cell's contents to be visible on the
screen, but will not allow the same to be printed?  Thanks.
Michael

I´ve got this macro in a workbook (inside Thisworkbook), and i need it
not to get copied when i save as...  ; so original won´t change.
Private Sub Workbook_Activate()
Application.DisplayFullScreen = True

I need to create a dynamic range, but I am coming up short on ideas on
how to accomplish this.
I have a program that finds the last row with data and enters new data
on the row below that, after the new data is entered I want to sort it

I have created a Master data worksheets, and one of the column in the master
worksheets indicates countries, for example Col A.
Then I have created a blank table in Worksheet 1, and in worksheet 1, column
B3 indicates the country code.

The code I'm going to refer to ultimately performs correctly, but results in
an unexpected caption display on application exit.
On CommandButton_Click two subroutines are called that alternate the
CommandButton Caption:

Hope some can help me here.
As you can see the example below, I want to write the Sub function only once
and able to run the sub function based which txtbox has been updated by a
user.  

I am setting up a userform and have placed a Combobox on it.
I want it to list Numerical values ONLY from a sheet named "Data Sheet for
Inspections", in Colum "A".
As data is input the Column and over time, there will only be a text value