Dear Experts,
I haven't yet received solution for my query below.
Please help.
Regards,
-- Forwarded message --
From: hemant shah
Date: Sun, Aug 19, 2012 at 12:56 PM
Subject: Need help on a formula
To: excel-macros
Dear Experts,
I am stuck up which my work in an exc
ance.
Regards,
Hemant
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Hi Group,
Pls explain,
What is Application.OnKey, Application.OnTime with syntex.
I had tried but couldn't understand how to use and when to use.
If Possible can give me an example.
Regards,
Hemant.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate t
Thanks to all for the Prompt reply.
The problem is solved.
Regards
Hemant Dange
On Dec 7, 9:55 pm, "dguillett1" wrote:
> A macro to populate column B
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> Fro
COLOUR that particular cell background.
Thanks and Regards
Hemant Dange
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
ata in this format and thus has to
enter ":" also.
Thanks
Regards
Hemant Dange
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n
Thanks for your reply.
The problem is resolved.
Regards
Hemant
On Nov 21, 6:18 pm, Manish Pandey wrote:
> Hi Hemant,
>
> Go to File>Excel Options>Proofing>Auto Correct Options, there uncheck
> 'internet and network path with hyperlink'. This will resolve cre
Hi i am suppose to enter "@" character in coumns. And whenever i
enter it, it opens OUTLOOK configuration.
How can i enter "@" character and without starting OUTLOOK in Excel
2007.
I don't want to change any settings of OUTLOOK.
Kindly provide solution.
Thanks
Hema
Team,
Can you please help me on my query.
I want you to work on attached file itself.
Waiting for your response
Regards,
-- Forwarded message --
From: hemant shah
Date: Wed, Aug 3, 2011 at 9:26 PM
Subject: $$Excel-Macros$$ Need help on Email from Excel
To: excel-macros
Dear
Dear Team,
I need a help on emailing from excel itself.
I have explained all the steps in the attached excel.
Regards,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi
I have a data in cells and and want to add Blank cells to existing data such
that every alternate cell will be empty.
e.g.
1
2
3
To
1
Blank
2
Blank
Thanks
--
--
Some important links for excel users:
1. Fol
Hi
I have a data in cells and i want to reformat it with every alternate
cell as empty cell in excel.
so without any data loss every alternate cell will be empty.
please give me the solution.
Thanks
--
--
Some impo
Hi,
Can you please help me on my query.
I have mentioned every thing in attached sheet.
Regards,
Hemant Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
Hi Team,
Can you please help on the attached file.
I have explained my query in the attached sheet.
Regards,
Hemant Shah
-- Forwarded message --
From:
Date: Mon, Sep 27, 2010 at 9:25 PM
Subject: Book1.xls
To: hemanthin...@gmail.com
Please do not print this email unless it
Hi,
Can you please help.
Regards,
Hemant Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
Hi Team,
Please help on the attached.
Thanks in advance.
Regards,
Hemant Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
:)
Hemant Hegde
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3
cific row from the
source sheet to an empty row next to the used range!
.
.
.
... pls attach your workbook!!
:)
Hemant Hegde
On 7 June 2010 09:59, Amanda wrote:
> Hi all,
>
> I'm stuck on a macro I'm working on. I'm uploading an example sheet.
>
> I have a list
Hi
You may also
1) sort the column (say A)
2) write this formula in an empty (or insert a new one) column next to A (B)
=A2=A1
3) Filter column B for all "TRUE" values and delete entire rows of the
filtered range!
:)
Hemant Hegde
On 8 June 2010 19:34, ashish koul wrote:
> fi
you can download it from this link
*http://www.easy-share.com/1909713544/Excel 2007 Bible.pdf
Regards
Hemant Koranne
*
On Fri, May 14, 2010 at 10:06 AM, Vikas Chouhan wrote:
> me also send pleasvikask...@gmail.com
>
> On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n.
Yes you can put filters to 2 or more times in Excel
The Trick is first time you put the normal filters.
and 2nd and onwards choose the data you wanna put filters and go to insert
table select the range click on "My Table has Headers"
and it is done.
Example attached
Regards
Hemant K
Dear Ajinkya & Vikas
Thanks for providing download link.
Hegards
Hemant
On Wed, Apr 7, 2010 at 7:00 PM, ajinkya natu wrote:
> Hi Hemant,
>
> I suppose this is what ur looking for...the file size is around 50MB so had
> to upload it on 4shared.
>
> http://www.4shared.com/
Hi Group,
Any one have this book pls provide it.
--
Regards
Hemant Koranne
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Here is the solution attached you can do it with the help of sumproduct
formula or with Sumif Formula
Regards
Hemant
On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh wrote:
>
> hi
>
> i have a worksheet where sizes and qty are maintained for each item in this
> way
>
> 460*12 P
ahead.
Thanks & Regards
Hemant
On Fri, Apr 2, 2010 at 8:56 PM, ayush jain wrote:
> Dear Members,
>
> Thanks for all your contribution to the group.
>
> The group has successfully completed three years. On this occasion, I would
> like to launch an eBook on excel shortcuts
Hi All,
Here is the link for the following great book for beginners in field of
Macros
http://cid-8debefc810167f39.skydrive.live.com/self.aspx/.Public/Excel%202007%20Macros%20Made%20Easy.pdf?lc=16393
Regards
Hemant Koranne
sert ribbon in MS Excel 2007
Click on Table "Create Table" Window will open
*
*Select the data range*
*Mark My Table has headers option
*
*And repeat same function for another range you will get the desired
results.
*
*
t;<><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and suppor
Can you send that html file
Regards
Hemant
On Thu, Jan 28, 2010 at 9:17 PM, Murtaza Dalal wrote:
> Naah Ankur it didnt serve the purpose. I've created an HTML page. is there
> an HTML code for saving data in excel.
>
> On Wed, Jan 27, 2010 at 12:18 PM, ankur wrote:
>
>&g
Hi Team
Can you pls help me with my question.
Every thing is mentioned in the attached sheet.
Pls help,
Regards,
Hemant Shah
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text
ooks is
opened in a separate instance of Excel! In this case when you try to copy
sheets, you wont see the name of the destination workbook in the menu!
In that case use CTRL+O rather that doubleclicking on the file icon to open
those workbooks..
:)
Good luck
Hemant Hegde
2009/12/2 Amitabh Bos
hidden column must contain a value of data type Integer
which I have to access many times within code.
Is there any *other* way to include a hidden value for each list item of a
combobox or a listbox in *VB6*?
Hemant Hegde
Hi
Please tell me the difference between ADODC and ADODB
and how to move to next record using ADODC. I didnt see any method like
Adodc1.MoveNext
Hemant Hegde
--
--
Some important links for excel users:
1. Excel
If it has already been converted into date format and you want to reverse
it, use
=Text(date,"yy-mm-dd") or
=Text(date,"dd-mm-yy") the way you want
and then remove formulae by pasting only the values
Hemant Hegde
2009/11/27 Norman May
> Jitesh
>
> Try
Is it windows?
If you want to use VBA for that, filecopy() function should help
Hemant Hegde
2009/11/25 Peetu
> There are free utilities available such as Allways Sync which can
> synchronize your data between two locations.
>
> On Nov 25, 3:52 pm, Aindril De wrote:
>
tore the sheet names afterwards
Hemant Hegde
2009/11/25 RolfJ
> You should provide a bit more detail. What's the formula? Which
> characters do you need to change?
>
> On Nov 24, 2:51 am, nikhil deshpande wrote:
> > Dear all,
> >
> > I need to change character
o excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><&
Here is another code I wrote but could not make much use of it
In the attached excel file, I have a frame inside a sheet which I wanted to
be able to move by drag and drop...
It is working fine.
See if you can use that in you application
--
-
d use the dimensions of its parent aplication. Otherwise, you may
also specify the percentage of how much you want to strech/shrink the
userform.
eg: call mzoom(userform1, 120,120)
or just
call mzoom(userform1)
Thanking y
Why not we share some of our own useful codes or techniques (which can not
be easily found by a google search) which will save lot of effort and time?
:)
I am going to post some of the vb codes I wrote or got on the net.
I will post a function (tomorrow because I don't have it here!) I wrote
which
Hello Everyone,
Can you help me with my query. I have updated everything i require in
the attached excel.
Regards,
Hemant Shah
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are
lue1)
End Sub
Result I want is "Hello World"
But I am getting "ERROR 2015"
Please run this code and suggst me if there is any way to evaluate a string
argument
With regards
Hemant Hegde
--
--
Hi
Its because you have protected the workbook.
Unprotect it
Press Alt+t p w and then provide the password and then try :)
Hemant Hegde
2009/11/12 mahesh parab
> Dear All
>
> In attach sheet when i try to unhide sheet i am getting caption error.
> steps are mention on below
ogle
it or attach an example workbook here so that I can tell you how to start
with it if you are interested.
With Regards
Hemant Hegde
2009/11/13 DEBASHIS BANERJEE
>
>
> -- Forwarded message --
> From: DEBASHIS BANERJEE
> Date: Nov 12, 2009 1:34 PM
> Subject: $
on the net can I get examples (open code of course) of working *.XLL
files?
If you know it yourself and want to help me, It will be very very nice and I
will be grateful to you for the help..
thanking you
Hemant Hegde
2009/11/12 Paul Schreiner
> I'm not sure of any other w
lowed are exhausted.
If you can explain the reason and importance of doing it, we may be able to
give you a suitable solution
Hemant Hegde
2009/11/10 OSAVentures Calamba
> dear gurus,
>
> say i have a worksheet, but i want to limit the printing of this worksheet
> to 10 times only
; to a random access file as a single
record (ie. without writing each property of the variable separately which I
cant avoid while writing a binary file!)
The problem is that I dont want to change much of code I already wrote!
With regards
Hemant Hegde
On 09/11/2009, Paul wrote:
>
>
can help
write
If not isblank(target) then:thisworkbook.close(false)
inside worksheet_change() event
With regards
Hemant Hegde
On 10/11/2009, OSAVentures Calamba wrote:
>
> Dear Paul and gurus,
>
> I want to find the last row. Is this OK?
>
> Private Sub Worksheet_Change(
me if I can do it in some other way. I heard
"*.DLL" and *.XLL" files are faster? will these help?
Thank You
Hemant Hegde
On 10/11/2009, RolfJ wrote:
>
>
> Please explain why you don't save the worksheet resulting from your
> calculations in the intrinsic Excel
> cell? Suggestions appreciated.
>
> Tommy
>
> Sub New_Name()
> Name = Application.InputBox("Enter New Name")
> Copy.Name
> Range("A1").Select
> ActiveSheet.Paste
> End Sub
>
> >
>
--
Hemant Hegde
--~--~-~--~~~---~-
ly it back to the cell.
Any better Idea?
Im sorry if I failed to explain correctly what i want to do!
Can I get all the formatting of a cell as a single number or a string by any
means?
Professional programmers help me please
--
Hemant
howing input table & expected output
>
> I will be really grateful to all of you if you help me in creating macro
> where i can get the output as expected.
>
> *Thanks & Regards
> Prasad Gadgil
>
NGTH (eg: you ALWAYS don't want the first 5 digits of a
number)
3) If none of the above are applicable, just see how you identify
the information you require from a raw data, and tell the computer to do the
same! Well the computer may ask you to give each and every break-up of the
procedure!
gt; in Ms Excel ?
>
>
>
> --
> sudhir
>
> >
>
--
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video
I guess when you are passing some values to a sub, You should use "Call"
keyword
Try
Call Modul1.Get_Param(CInt(TextBox1.Text), CInt(TextBox2.Text))
Hemant Hegde
2009/11/6 laudes
>
> Hi all
>
> I've got a problem and it seems, that I'm not able to solve it
ble.
But why do you want to do that?
I, by experience know that its better to have data in a single sheet in a
table format than in different sheets so that we can use advanced features
of excel like pivot tables effectively.
Hemant Hegde
2009/11/3 Chanti
>
>
> Hi Team,
>>
>
Hi
I did not understand what you want to accomplish with a VBA code.
But can i pls know why you hate recorded macros?
Hemant Hegde
2009/11/2 vinod rao
> HI Team,
>
> Need a VBA code for doing pivot - below condition is needed
>
>
>
>
> 1
> Z F C
> I a
good luck friend ! :)
Hemant Hegde
2009/11/1 karthikeyan sankaran
> I have download this data from PDF.Now I want to create pivotTable through
> this data. <http://groups.google.com/group/excel-macros/
Hi Pooja
Pls find the attached sheet
Hemant Hegde
2009/10/31 Pooja Sharma
> Hi All,
>
> I need your help in extracting some words (having defined format) from one
> cell in another cell. Attached is a sheet where I have mentioned the case
> and the solution I require.
>
&g
Hi Anish
I Have corrected the code and it works fine now:
Pls note that it runs on the ACTIVE SHEET. you may change it later.
Sub Test()
j = 1
While j <= Cells(65000, 1).End(xlUp).Row
For i = 2 To Sheets("Replace_Values").Cells(65000, 1).End(xlUp).Row
If Cells(j, 1) Like Sheets("Replace_Valu
Hi
I have an excel sheet (attached) having a table with 3 columns, "Entry
Number", "Party Name" and "Amount"
In the result sheet I have:
1) In the row first row: selected values from "Party Name"
2) In the first column: selected values from "Party Name" (though from the
same field as the first
Hi
See attached file
2009/10/29 Mahesh
> Dear Frineds,
>
> Please help me to solve the problem in attached sheet.
>
>
>
>
> --
> With Love,
> Mahesh Bi
will post it back if I get any success..
With regards,
Hemant
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins do
ve that part of the code.
Is there any way eg. I will digitally sign the workbook or some other person
will certify it and the above situation be avoided?
Thanking you
Hemant Hegde
--~--~-~--~~~---~--~~
--
.
Visit my profile or search the group. You will find the attachment
Best regards,
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials
figure out why StopTimer() is not working?
>
> Regards
> Praveen
>
> >
>
--
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and
he name of the RefEdit control
is RefEdit1)
On error resume next
Range(RefEdit1).interior.colorindex=rgb(100,20,20)
Best regards
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important
ILE. ALL OTHER THINGS SUCH AS PARTY NAME,B.NO. PASTE
> EASILY , BUT WHEN WE PASTE THE DATE IT'S VALIDATE OPTION DOES NOT VALIDATE
> IT WHICH IS ESSENTIAL. SO, PLEASE DO THE FAVOR FOR ME TO REDUCE MY WORK.
> > >
> > > THANKS & REGARDS,
> > > RAHUL GARG,
> &
Sheets("Replace Values").cells(i,1) then
cells(j,1)=Sheets("Replace Values").cells(i,2)
else
cells(j,1)=Sheets("Replace Values").cells(i,3)
endif
Next i
'---
j = j+1
'Wend!
I have not tested this code yet.
Pl
TS*" Then
> Cells(i, 4) = "FINANACE / ACCOUNTING"
> Else
> If Cells(i, 2).Value Like "*SALES*" Then
> Cells(i, 4) = "SALES"
> *(IN BETWEEN THR R MORE THAN 100 IF CONDITIONS LIKE THIS)*
> endif
> endif
> endif
> i=i+1
> wend
> end
care of the overriding conditions
>
> This way I can have a control of the data being copied to many sheets
> from the master sheet (to avoid duplication) and also can consolidate
> the samples chosen for various users to a single sheet.
>
> If nee
t.Cells(1, 1) = "It works!"
'---
X.DisplayAlerts = False
X.ActiveWorkbook.SaveAs "C:\temp.xls"
X.DisplayAlerts = True
A” or “B” automatic data display,(looks like
> Vlookup formula)
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde
> *Sent:* Thursday, October 22, 2009 8:45 PM
> *To:* excel-macros@googlegroups.
t
>
> 13
>
> 4
>
> pankaj
>
> 14
>
> 5
>
> hitendra
>
>
> I want it to be
>
> Row No.
>
> sr. no.
>
> name
>
> 10
>
> 1
>
> sachin
>
> 11
>
>
>
>
>
> 12
>
> 2
>
> piyus
amit
15
16
4
pankaj
17
18
5
hitendra
How can i add all the alternate rows together.
Thanks & Regards
Hemant
--~--~-~--~~~---~--~~
--
Some important links for excel u
Hemant Hegde
*
*
2009/10/22
> Can any one solved my problem??
>
>
>
>
>
> *Malek Sarfraj***
>
>
>
>
>
> *DISCLAIMER:*
>
> Please note that this e-mail and its attachments are intended for the named
> addressee only and may contain information th
Use this code Jp,
Sub get_path ()
Dim x as string
x=Application.getopenfilename
If not x="FALSE" then: Activecell=x
End sub
:)
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some
then saved as a new
> workbook. The original workbook is set to reference an xla add-in that
> I made but the newly created workbook doesn't have the reference.
>
> Can someone please tell me how to set the reference to a custom made
> add
ithout depending on a configured MS Outlook account.
Thank you
:)
--
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Tex
Use this code friend
Sub Test()
On Error GoTo Ext:
Dim X As Range
Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
X.Cells(1, 1) = 1
X.Cells(1, 2) = 30
Ext:
Exit Sub
--
He
Thank you so much Michael :)
I am going to test it now!
On Oct 15, 2:55 pm, Michael wrote:
> Why does no one seem to use the [A1] notation in preferece to Range
> ("A1")?
>
> [A1].Select seems easier than
> Range("A1").Select
>
> Thanks
>
> Michael
--~--~-~--~~~-
I suggest
Trial and error and
Excel help file :)
On Oct 16, 11:49 am, summu wrote:
> 1)I am Unable decide Starting and Endling of VBA
> Can any body suggest good book on EXcel Vba or any other good sources
>
> 2) How to learn Financial Modeling ,can anybody suggest me
> Good books to learn
I think ARRAY FORMULAE may make it more simpler..
Its only today that I learnt to use array formulae...
Go to www.cpearson.com
They have put excellent excel tips on excel and VBA.
But they have not mentioned that using cell range addresses like "A:A"
does not work with array formulas but we h
Hi friend
I have tried to solve. Please find the attachment
Happy Deepavali to all
Hemant Hegde
2009/10/15 vinod rao
> HI Expert Guru,
>
> I need a formula in finding status in column G. For reference the result
> expected is given in column J.
>
> The contion is th
Good Wishes for all the group members on this Diwali. The festival of lights
bring all lights of joys and happiness to all of us.
Regards
Hemant
On Fri, Oct 16, 2009 at 8:37 AM, Aindril De wrote:
> Dear Fellow Group Members,
>
> Wish you All and Your Families a Happy and Prospero
Hi Prashant
Please find the attached solution
Hemant Hegde
2009/10/11 Prashant Bhawar
>
> Plz help here i attached a problem file with required ans. plz help me
> --
> Warm Regard
>
> Prashant Bhawar
>
> ( CA Final )
&g
Hi friends
We know that there are loads of softwares available to crack VBA
passwords.
But can i convert some part of my VBA code to a *.dll file and use? (I
guess it should be a bit harder to crack)
I have worked with excel for 2 years and have some programming
knowledge but I am nowhere near
et us know about more specific requirement if any.
Regards
Hemant Hegde
On Sep 24, 4:45 pm, Abhishek Jain wrote:
> Dear All,
>
> I am stuck at this. All I need to do is to extract a range, say, J18:J35,
> from Sheet1 of all files placed in a single folder.
>
> Additional details (in cas
Hi
Good day cadunn and Dave
I think this is because in VBA you cant use double quotes directly
inside a text string.
Just use& Chr(34) & Instead of double quotes
Hemant Hegde
On Sep 24, 9:30 am, Dave Bonallack wrote:
> Hi,
>
> Try this:
>
> Ra
know how to
create a new icon for my custom type file.
Any help regarding this is highly appreciated
Thank you in advance
:)
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links fo
No Replies! :(
On Sep 19, 2:44 pm, Hemant wrote:
> Good day friends :)
>
> I have an excel workbook with one of its hidden (XlVeryHidden) sheets
> contains a link to my web site and gets updated every time the
> workbook is opened and once in 15 minutes.
>
> When I will p
---
'3) Paste the following code in the module "Sheet1(Sheet1)"
ComboBox1_change()
sheets(combobox1).activate
end sub
Hemant Hegde
On Sep 22, 7:41 pm, Mohit Agarwal wrote:
> Hi,
> Is it possible to go to create a drop down list of names of all the
> worksh
I dont know why in some computers excel stores date in mm/dd/ and
in some as dd/mm/
BUT
You can convert the same to any format without using any formula or a
macro.
Just select the column containing the data (Date. in whatever format!
like 1.13.2009, or 13-1-2009, or 13/1\2009)
Go to
Friend!
If you are not confused about the functions =TEXT() (in excel) and
=Format() in VBA, (like i was confused) You can just rename your
macro in the code module by pressing ALT+F11 to get the function
"Forrmat" working again.
On Sep 21, 5:41 pm, Doug wrote:
> I'm so annoyed at myself! I r
one seems to know why!
Let me just try to explain the formula
=VLOOKUP( , , , )
=COUNTIF(,) will give you the count of search
term in the range. returns zero if its not found
Hemant Hegde
On Sep 21, 9:16 pm, Sonal Gadgil wrote:
> Hi...
>
> I am new in this group.
>
> I a
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,31)
:)
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel an
Yeah
You can use Application.ScreenUpdating=False
But you can also:
1) avoid codes like ".Select" , ".Activate"
2) If you are formatting a sheet, Create a sheet which is already
formatted and keep it hidden. And then you can just copy the hidden
sheet and paste the format the new sheet.
It w
This code will definetly serve your purpose. Use
Location = "E:\abdc"
Filename = "MyFile_Backup_" & Format(Now(),"YY-MM-DD HH:MM:SS") &
".xls"
Thisworkbook.SaveCopyAs (Location & Filename)
Please note that I have not use "SaveAs "
You can this code and see what is the difference between the
1) Sort the column which you want to filter (say column A)
2) Insert a column to the right of sorted column (Column B)
3) In the inserted column, enter this formula (Say in Row 2)
=A1=A2
4) drag the formula till the end of the table
5) Now use an autofilter and select all the cells having TRUE
you in advance and It will be of great help! If I will
be able to do this, I can make automatic updates to my workbooks and
send pop up messages etc. when I would have distributed the workbook
to many people. :)
Hemant Hegde
1 - 100 of 110 matches
Mail list logo
