Dear Sandip,
This is because the original row does'nt have the formula in cells (Q7:U7).
Macro is doing good as per you initial requirement which was to copy the
formula from previous row to newly inserted row. Requirements are
reproduced below:-
*"After the addition of new row7, the old row7 wi
I am building a custom class. It includes an add method.However, I
would like the add method
to include the "after:=" and "before:=" parameters similar to those
found with the worksheets.add
how do I achieve that goal?
Bil
--
--
Ashish,
It's absoulutely possible. Can you attach a few word files for example.
Regards,
Alokeshwar
09891442001
_
"There are known knowns. These are things we know that we know. There are known
unk
Dear All,
This may possibly not be the correct forum to ask my question. My
problem is as follows:
I have a word document file in the following format;
Name
Address1
Address2
Area
City - Pincode
(M)
I now need to extract only the number which is mentioned after the
field (M) into an excel file.
Dear All
I herewith attach sample workbook, I need help for macro which autofilter
data & copy to another sheet.
below mention are the steps, I will appreciate any help on this.
Auto Filter Date 2(Column C)
Select First Month (eg.May 09)
Auto Filter Date 1 (Column B)
from the month which filter i
Karthik,
The following will do the trick:
Set aRange=[define the range that contains the cells you wish to
clear]
For each aCell in aRange.Cells
If Not aCell.HasFormula then
aCell.Clear
End If
Next aCell
Best regards,
Justin
On Jan 2, 4:00 am, Karthik Naidu wrote:
> Hi all am new to this
Karthik,
The following routine will do the trick:
Set aRange=[Define the range you want to clear cells in]
For each aCell in aRange.Cells
next aCell
Best regards,
Justin
On Jan 2, 4:00 am, Karthik Naidu wrote:
> Hi all am new to this grp..
> Happy New Year.
>
> Query: in macros how it ca
Dear Karthik,
Include following lines in your code when you have selected the respective
region.
Selection.SpecialCells(xlCellTypeConstants, 23).Select
Selection.ClearContents
Check the attached file for more understanding.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
M
