I'm trying to import data from a closed excel wkbk to an open excel wkbk. I
recorded the macro, made some adjustments, and sometimes it works, but most
the time it does not. Not sure where my problem(s) are, and I'm hoping that
you can help me. This is what I wrote/recorded:

I have a combobox that has 8 listed items lets say 1-8. I would like
where if you choose 3 in the combobox cell D6 changes to 3 then if I
choose 6 cell chooses 6 and so, whatever number i choose changes D6 to
equal that value. Also I have a chart macro attached to each number

Is it possible to import a txt file into Excel and keep the leading
zero's?  I am using vbscript to import the text file, the text file
contains a user reference which sometimes contains a number with a
leading zero i.e. 0111.  This number is imported as 111.  The user

Hello;
Sorry to bring up this old problem, but suddenly the screen flickers when I
click the button to run a relatively simple macro.
The Application.ScreenUpdating = False

I have a listbox with 3 columns. The first 2 have their width set to 0
and the third is left to default i.e. size itself (theorectically).
The problem i'm having is that even though the contents of the 3rd
column are greater than the width of the listbox the horizontal

i have a spreadsheet with sheets named as follows
St1, St2, St3, St4, St5 etc...
I would like to enter a number into a cell on a separate sheet that will
result in

How can I restrict the size of an Excel 2007 spreadsheet to be compatable
with Excel 2003? I have many macro programs as parts of about 30 different
spreadsheets in Excel XP to Excel 2003 that will not work in Excel 2007.
Problems come from clearing data below bottom row to ...

I have a group of cells (100 of them) that I need to name individually. The
name of the cells would be "Line1LP" through "Line100LP". in column A, I
numbered each cell.
cell A1 = 1

Can a template be created and stored in a vb module within another workbook
or does the vb code of the other workbook have to point to it to use it? I
have a lot of data that I am trying to copy to a formatted sheet with merged
cells, however when the search for data code fires ...

I'm bringing in data from various worksheets into one worksheet - with each
of the worksheets being copied into the last row.  Problem : I'd like to
change the existing script from PasteSpecial to paste so I do not loose the
time format.  Currently it is changing the data into a ...

What is wrong with this code:
If Not Sheets("Harrison 1") Is Nothing Then
       Sheets("Harrison 1").Select
       Range("A3:C3").Select

I need a formula for:
Sales Report:
A              B           c             d
Item        qty        Price      month

With the exception of macros, I'm very proficient with Excel. All I really
know how to do with macros is record them and play them back. Unfortunately,
I need to do something a little more complicated. I have a table of variables
that feed into a series of lookups and data tables ...

I have a conditional formatting applied to my worksheet (Seattle)
within the spreadsheet.  I would like to drop the Excel conditional
formatting and create a Excel VBA button that would apply the same
validations as the condtional formatting.

I am looking at some VBA code in an effort to help someone.  One sub
has the following statements juxtaposed:
foobar = 1234
foobar = 1234