Hi Ashish,
Thanks for the update and sharing them.
I would think we can include
1. Duplicate entries in a column.
Sub Duplicate_Red()
Application.ScreenUpdating = False
Rng = Selection.Rows.Count
For i = Rng To 1 Step -1
myCheck = ActiveCell
ActiveCell.Offset(1, 0).Select
For j = 1 T
Can you simply format the cells to SPECIAL then choose PHONE NUMBER?
Norman
On Tue, Jun 9, 2009 at 7:38 AM, amrahs k wrote:
> Dear Harmeet and Team,
>
> I have attached a sample file for your reference with my simple query.
>
> Could you please look into this and advice me to proceed further.
>
thanks for this shortcut
its cul
On Tue, Jun 9, 2009 at 6:18 AM, Abdul Rasheed wrote:
> Name : Abdul Rasheed
> Subject : Save As
> Tip : Press F12
>
> Regards
> Abdul Rasheed
>
> >
>
--~--~-~--~~~---~--~~
--
Hi Friends,
I have a gift for all the users who are helping new users to excel
themselves in excel.
It doesn't mean that beginners cannot use this tool, it is for everyone.
enjoy
Getting frustrate, because of lots of Login/Passwords for different sites
and you cannot manage your credentials
Thanx a ton Dave
On Tue, Jun 9, 2009 at 8:15 AM, Dave Bonallack wrote:
> Hi Harmeet,
> I think this is a very good tip.
> Regards - Dave.
>
> --
> Date: Tue, 9 Jun 2009 00:29:31 +0530
> Subject: $$Excel-Macros$$ Re:Win PRIZE>
> From: harmeet.hew...@gmail.com
> To:
Dear Ajay,
Thanks a lot. It will be of immense use to me. One last thing. Is it possible
to refer the cell by cell- name instead of cell address so that it works
whenever I save the file from any sheet. E.g. if I name the cell B10 is
“BSDIFFERENCE” and in the code I refer it like if “BSDIFFEREN
Yes, I could do it that way. I try to avoid loops as much as possible
though. I was curious if there was a way, because it seems odd that
you can not "see" filtered data.
On Jun 8, 10:40 pm, Dave Bonallack wrote:
> Hi,
>
> If the FIND thingy doesn't work with filter-hidden rows, try just loopi
Hi Vivek,
I told you to write the code under ThisWorkbok but you wrote the code under
Sheet1.
Check the attached file.
On Tue, Jun 9, 2009 at 3:10 PM, vivek jain wrote:
> Dear Ajay,
>
>
>
> I tried the solution provided by you. But I couldn’t do it. I am attatching
> the file in which I co
Hi Friends,
Here is the updated collection of VBA Macros on http://www.excelitems.com.
If there is any general macro idea in your mind that could be useful to
excel users, please do reply to this mail. I'll post it on
http://www.excelitems.com with your name.
*Please note the links suffixed with
Dear Ajay,
I tried the solution provided by you. But I couldn’t do it. I am attatching the
file in which I copied the code provided by you. Please have a look at it and
let me know where I went wrong.
Thanks & Regards..
CA Vivek Jain
From: excel-macros@googlegroups.com [mailto:exc
10 matches
Mail list logo