i need to replace the string in column c. For ex the string DOOR INSTL
should be converted to DOOR INSTALATION. DOOR ASSY to convert it to
DOOR ASSEMBLY
i have written a code which changes INSTL to INSTALLATION and so on.

I have a workbook with VBA programming in which caused Excel to close for
some reason. Now when I go to re-open the workbook and select either enable
macros or disable macros at the prompt. I receive an error message which says
the workbook is " locked for editing' and can only ...

I am retrieving a table from a webpage and the data is sorted in
reverse order (by date).  It is a dynamic range but I compute the last
row of the range before processing.  I am currently resorting the data
so I can process it by date (ascending).  My question is how can

If Anyone could give me a hand....
Cell E33 value is "$2,793.70"
Cell F33 value is "$450.00"
My code rounds up the result and returns the value 3244. I need the value

I have a scheduled macro that downloads data every 10 minutes. A problem
arises though when the user has another workbook active when the macro is
running. The macro tries to run in the active workbook.
I could make the macro activate the correct workbook before doing the

I did the following:
Sub test()
   Dim cell As Range
   Set cell = ActiveCell

I want to basically update the date fields according to date, I tried putting
the function "=Todaysdate()" within my sheet but when my code tries to copy
it, it brings up an error. I want my dates on one sheet to copy from the
dates in another sheet on the same workbook, I could ...

I need to fill a Column (B) with a value of "1" in every cell that is null up
to the last row having a value in Column (A).  There are no empty cells in
column A up to the last row with data in the spreadsheet.  I can not
accomplish through a recorded macro.  Can anybody help me ...

I get this message:
Automation error.  The specified module could not be found.
When I run this code:
Sub CreateTask()

I am trying to insert additional logic here ******
Sub HiLite()
For Each cll In Range("A:A")
If cll.Value = "C" Or cll.Value = "c" Then

I have a large spreadsheet with macros.  Sometimes when I open this
spreadsheet, the enable/disable dialogue box doesn't appear, and the file is
opened w/out enabling the macros.  Is there a way to:  1) make sure dialogue
box always appears; or 2) enable the macros after the file ...

If i have a formula in workbook "HOME". For example the formula is =sum(a1+b1).
If I copy the whole page and paste it into a new workbook named "HOUSE" the
formula comes over as ='HOME'(a1+b1)
What could I do to make the formula stay the same regardless of what

I am looking for a way to have a macro that will automatically select a
range by the cells in the ranges background color. I have an area that is a
set width, (cells H-K) but the length can vary depending on other information
in the sheet. I have conditional formatting set to ...

the floowing line is coming from the excel help
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
How can i use this function in macro where the lookup_value is in A1 format,
the table_array is a variable (rng) ?

I have a workbook with VBA programming in which caused Excel to close for
some reason. Now when I go to re-open the workbook and select either enable
macros or disable macros at the prompt. I receive an error message which says
the workbook is " locked for editing' and can only ...