Dear Pravin,
Replaced -
ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates _
Columns:=3, Header:=xlYes
by
ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates Columns:=Array(2, 3), _
Header:=xlYes
Might help you out.
Regards,
Chaya
On Mon, Apr 15, 2013 at 11:12
Hi Chaya
It must be check in col. B & C and not only C. Pl check and inform.
Regards
Pravin.
On Mon, Apr 15, 2013 at 11:08 AM, Chaya wrote:
> Dear Pravin,
>
> Check the below if it will work out. and you can change the row
> number as you like. e.g. AL85 to AL5000 as per your data.
>
>
>
Dear Pravin,
Check the below if it will work out. and you can change the row number
as you like. e.g. AL85 to AL5000 as per your data.
Sub Remove_Duplicate()
' Removing Duplicate in c column.
Application.ScreenUpdating = False
Sheets("FNDWRR").Select
Sheets("FNDWRR").Copy After:
Hello Team
I am looking for VBA code to print a active sheet into pdf without user
interface.
Suppose the cell AA1 contains the address where the pdf to be stored and
Cell AA2 contains the name by which the pdf to be stored.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:R
thanks for your help in advance...
On Sun, Apr 14, 2013 at 3:51 PM, pavithra murthy wrote:
> Hello,
>
> I tried writing a macro code. Will give you the result shortly
>
> Thanks,
> Pavithra
>
> --
Hello,
I tried writing a macro code. Will give you the result shortly
Thanks,
Pavithra
---
On Sun, Apr 14, 2013 at 3:58 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrot
hi Experts,
Need your help , as i could not club both sheets in new workbook.
Thanks,
Raj
On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Hi friends,
>
> Please assist with Advance filter issue,
>
> i have created a macro which will be taking u