Macro Help in Excel 2007?
I want to delete particular rows only in my work sheet which contains #N/A
in a particular column?
Assuming the column containing the #N/A errors is column A, and i need to
delete the entire row where '#N/A' if found in column A.
Plz help with macro code which should
try this code
assuming you have data in col a to col c and you want to delete all records
with #n/a in col C
Sub TEST()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
If Sheets(1).FilterMode Then
Sheets(1).ShowAllData
End If
Sheets(1).Range("A1:C" & R
I processed 3,000 records (and removed 1,000)
in about 30 seconds
Paul S
From: Prabhu
To: excel-macros@googlegroups.com
Sent: Fri, April 15, 2011 6:29:18 AM
Subject: $$Excel-Macros$$ Macro Help in Excel 2007?
Macro Help in Excel 2007?
I want to delete parti
Hi Ashish,
Thanks, But when i run the macro i had an issue
1) It is woking only on the Sheet 1 only not other sheet
2) I want to use this code with other macro as a Continuation Plz help from
which line i have to copy to my exising macro code.
Regards,
Prabhu
--
---
change
Sheets(1)
as per your requirement
activesheet or Sheets(" name of sheet")
On Fri, Apr 15, 2011 at 11:57 PM, Prabhu wrote:
> Hi Ashish,
>
> Thanks, But when i run the macro i had an issue
>
> 1) It is woking only on the Sheet 1 only not other sheet
>
> 2) I want to use this code with
Hi ashish,
Is there any way to keep common code for all sheet?
Because i may have to use this code on various sheet on many time.
On Sat, Apr 16, 2011 at 11:35 AM, ashish koul wrote:
> change
>
> Sheets(1)
>
> as per your requirement
>
> activesheet or Sheets(" name of sheet")
>
>
>
> On Fri
