Hi. I have a list in column a of letters and numbers. I want to copy
the cells where there are letters (4letters) only and place them in the
same positon in column H - excluding all numbers.
Formula or vb?

In Excel, how can I validate that a cell has data? If there are blank cells,
I would like a message box when the user clicks on file to save or send.  Any
help would be greatly appreciated.

I need a macros to autofill rows. I am working on one now but have a few
problems. I have one spreadsheet that has a row for each employee for each
payperiod. It has the employee name, check number, date, hours worked,
vacation sick, pay etc, earnings. The hours worked may be in ...

I'm trying to make excel display the current date and time in one
column when I enter a value into another column. The code I have is as
follows:
Private Sub Worksheet_Change(ByVal Target As Range)

How can I loop through rows 14 to 33 and set the value in the A cell
returned by this function for each rows:
Range("A14").Value = CalculateScore(B14, C14, D14)
Regards,

I hope I explain this right.
In the process of displaying information on a sheet I have created a
form that displays measurments in different text boxes. These values
are looked up as you enter manufature and model number into a couple of

Hi...
I have 3000 records. In column B there are sporadic #N/A values. I need some
nicely packaged code that will delete all rows where a #N/A appears in B, so
that there are no gaps in the rows. Sounds easy but I'm struggling.

I'm trying to generate a report and am having trouble with the formula.
Any help would be greatly appreciated.
Here is what I need to be able to do.
I have 6 worksheets in the same workbook, worksheets 1 - 5 are

Can someone tell me how to code a macro to display the current time is a
cell. I am able to get the date and time with using the Now coding, but can't
seem to get the only the hours and the minutes. I know this is an easy
fix...but help I'm a newbie

I have a group of about 20 Excel files in C:\Cars.
All the files begin with 5 zeros. For example 00000_redcar.xls,
00000_bluecar.xls.
I need a macro to replace the zeros in each file with another 5 digit

I have a 30 worksheet file, where each time I open it up, it asks to either
enable or disable a macro. There is no macro on this file when going to
Tools-Macros. I've check the file through VB and can't find any macro.
I checked personal.xls and there is no macro in that as well.

What is the best way to get the default .xla add-in path?
Will this always be Application.UserLibraryPath ?
Or should I use a function like this:
Function GetDefaultAddinPath(Optional strIdentifier _

hi,
I have the following:
Range("G6").Select
Range(Selection, Selection.End(xlToRight)).Select

Hi...
I have 3000 records. I want to delete 300 rows that share an auto filtered
value. The problem of course is that when I highlight the block to delete, it
deletes the rows that have't been filtered. Is there a way round this?

I am importing a file that varies in length from month to month into
Worksheet1. In worksheet2, I need to copy the formulas in Row A10 down the
same number of rows in Worksheet1.  I do not want a formula in Worksheet 2
referencing a empty row in Worksheet1.