I'm having problems trying to get the selected item in the combobox t
populate the existing row in the worksheet.  When I click on th
selected item in the combobox and save to the worksheet it adds th
item to the next empty row instead of using the existing row, creatin

Can anyone tell me why this macro will not PasteSpecial the Columnwidth
attribute(the one I marked with a double asterisk, 4th line from the end). It
handles the other PasteSpecials with no problem.
Sub ProcessWeeklyData()

I am trying to figure out if I can rename non-excel files with excel.
I have a sheet with my file names in column A
G:\New Folder\Blank DA 1594.FPK
G:\New Folder\DA 1594 Example.pdf

how to send a message to multable recipients from small office Xp

let's say i have a variable called fname (first name)
i want to write that value to a cell and make the font color red. but, there
could already be an fname in the cell, or there could be one added after this
one.

How we can track event of Drag and Drop???

I have the following code (from Ron de Bruin) which e-mails out a sheet
from my master file. I have set this sheet as protected but I wish to
stop the ability of copying the contents of the file to another
workbook. How would I set the temp e-mail file to "Read Only"?. I

Everyday I used to import the oracle database (Sales Data - Invoice
Numberwise) in Excel.
Now the data is almost about 1,50,000 rows and excel have a limitations of
65000 rows.

I am trying to do 3 things when I open up a file
1) Unprotect all worksheets in the file
2) Go to A1 in all sheets
3) Finally activate C6 in the sheet Current week

Is it possible to reflect the worksheet name by value in a cell?

I have a fairly large workbook with worksheets that contain a lot of
formulas and named ranges that reference other worksheets in the
workbook.  I'd like to be able to make templates based on two of the
worksheets, but when I copy them out of the workbook and try to use

I am working with 6 files. I need to copy the data from a sheet (within each
workbook/file) named 'substandard' and paste the information into the
'substandard' sheet in the master file.  To do this I have been opening the
master file, placing the cursor where I want the ...

The following is a modified code from this newsgriou
Sub MonthRange()
Dim iStart As Long
Dim iEnd As Long

I sure do need some help.  This is frustrating.  I've changed this a
hundred times trying to find the right combination and nothing is
working.  I'm trying to "delete" all rows where any cell in Column A is
emtpy, Column C is empty, Column A says SO NUMBER, Column C says LOG

ComboBox Properties:
ListFillRange:  C22:C28
LinkedCell:  AL16
BoundColumn:  1