Thanks for your help
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
In your macro:Sub sbCompareColumns_2()
iCntr = 1
Do While Cells(iCntr, 1) <> ""
If UCase(Cells(iCntr, 1)) = UCase(Cells(iCntr, 2)) Then
Cells(iCntr, 3) = "Matched"
Else
Cells(iCntr, 3) = "Not Matched"
End If
iCntr = iCntr + 1
Loop
http://tutorialway.com/use-named-range-in-excel/
helpful site
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
What you're asking is easily done, in hundreds of different ways!
The method you choose depends on your specific conditions and level of
expertise.Have you done VBA programming before? What have you tried?Does the
"destination" workbook already have sheets of the same name?Are you ADDING the
For your second question:Here's what I would do:
Open a NEW workbook and create two
macros:'Sub
Events_Enabled()
Application.EnableEvents = True
End Sub'
Sub
its perfect! thanks a lot... :)
Sent by Outlook for Android
On Mon, Jul 27, 2015 at 5:02 AM -0700, ashish koul koul.ash...@gmail.com
wrote:
use application.enableevents = false at the beginning
and application.enableevents = true at end
On Mon, Jul 27, 2015 at 5:29 PM, gargee
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells.Count = 1 Then
If Target.Address = $K$2 Then
' ADD UR CODE HERE
End If
End If
Application.EnableEvents = True
End Sub
On Mon, Jul 27, 2015 at 5:54 PM,
absolutely perfect now. thanks a lot. :) :)
Sent by Outlook for Android
On Mon, Jul 27, 2015 at 5:27 AM -0700, ashish koul koul.ash...@gmail.com
wrote:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells.Count = 1 Then
If
use application.enableevents = false at the beginning
and application.enableevents = true at end
On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote:
Dear Experts
I wrote a code to multiply or divide a range of numbers by 1000 if
depending on whether a user selects
Hello,
i just realized that it also runs the code when i change some other cell on the
sheet e.g i use some other validation on the sheet or calculate something
elsewhere , why would that happen.
i want it to run the code only when cell k2 is changed to a yes or no.
thanks again.
Sent
thanks
yes the problem is what you just said, each time you open the file the date
changes. in this case I find a vien code in Internet. the problem that
execute from i = 2 to i = 100 beyond the 100 code is not working. the code
you find in this link:
Please try to use function now() it gives the actual date and hour when
you write it. but it will updated each time you open the file ... and this
is not what you're looking for I think...
2015-05-21 16:43 GMT+01:00 siga eladebelhec...@gmail.com:
bonjour
je cherche un code vba qui affiche
without reading in deep of the code, you can just give to i a verry big
value this will solve your issue ?
2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com:
thanks
yes the problem is what you just said, each time you open the file the
date changes. in this case I find a
thanks
2015-05-21 17:18 GMT+01:00 Mustapha LMIDMANI lmidmani.musta...@gmail.com:
without reading in deep of the code, you can just give to i a verry big
value this will solve your issue ?
2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com:
thanks
yes the problem is
try this
Public Const oldnm As String = f1
Public Const newnm As String = test_f1
Sub renam_folders()
Dim fldpath As String
Dim fso As Object, folder1 As Object
fldpath = C:\Users\admin\Desktop\sample ' choose folder
Set fso = CreateObject(Scripting.FileSystemObject)
Set folder1 =
hi experts,
i got the answer for my latest post.
below is the one i found myself :
Sub clearcontents()
ActiveSheet.Cells.clearcontents
End Sub
Regards,
Prabhu R
On 15 May 2013 10:25, Prabhu Pinky prabhupin...@gmail.com wrote:
hi experts,
what is the code to clear the contents including
hi experts..
actually its not working...
kindly help me on this...it clears only sheet 1 contents... if i select
sheet 2 or other sheets and if i run the macro its not clearing. its works
only on sheet 1.
On 15 May 2013 10:35, Prabhu Pinky prabhupin...@gmail.com wrote:
hi experts,
i got
It should work for all sheets upon selection.
May be you have put it at a wrong place. See the attached example.
HTH
On Wed, May 15, 2013 at 10:55 AM, Prabhu Pinky prabhupin...@gmail.comwrote:
hi experts..
actually its not working...
kindly help me on this...it clears only sheet 1
Can you also provide a sample output?
On Tue, Mar 12, 2013 at 11:37 AM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
Once more help please, i am a new learner in macros, i love it. right now
i am learning by only recording the macros in excel. even i don't know how
to declare vaue and
Yes Sir,
If you see the attached sheet, there one button is there, please click
on that and go to second sheet. you will find that every time the datas
are shifting down
-Chaya
On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain abhishek@gmail.comwrote:
Can you also provide a sample
I still did not get your query. I have manually done what your code is
doing...the data is shifting down because you added 54 rows there, but
that's not my point of concern.
I also did not understand what you meant by you have to click 6000 times.
All your code is doing is copy and paste. Same
Awesome Anil sir, as i expected you have solved my query. Thanks all for
assist.
Thanks once again.
Sir, Can you please explain me your coding. step by step so that i can
understand:
Dim a As Integer
Set ws = Worksheets(2)
Dim b As String
irow =
I have shared it but it not open from other PC except main (Lenovo)
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com
From: v...@vabs.in
Date: Tue, 13 Nov 2012 04:56:33 +
Hi,
You can access by this way also but for this to be worked your D drive should
(Lenovo)
--
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com
From: v...@vabs.in
Date: Tue, 13 Nov 2012 04:56:33 +
Hi,
You can access by this way also but for this to be worked your D drive
should be shared.
Cheerz..
Sent on my
sajidwi...@hotmail.com
To: Sundarvelan Natarajan excel-macros@googlegroups.com
Sent: Mon, November 12, 2012 11:13:02 PM
Subject: RE: $$Excel-Macros$$ Code Problem
Dear My first machine name is Lenovo, 2nd name is Hp, third name id Dell. in
all the machines D:\ drives is there, same path.
Can i write
You really should use a better subject.
just about everyone who posts here has a code problem
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.
Some people here are EXPERTS in the use of pivot tables.
dell.
please suggest me.
Awaiting
sajid
Date: Mon, 12 Nov 2012 07:05:15 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com
You really should use a better subject.
just about everyone who posts here has a code problem
You have
Natarajanexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Code Problem
Dear My first machine name is Lenovo, 2nd name is Hp, third name id Dell. in
all the machines D:\ drives is there, same path.
Can i write \\Lenovo\d\12-13\book1.xls or \\Hp
see if it helps
cell c3 enter this formula
=SUMPRODUCT(--($A$104:$A$65536=DATE(LEFT($A3,4),RIGHT($A3,2),1)),--($A$104:$A$65536DATE(LEFT($A3,4),RIGHT($A3,2)+1,1)),--($B$104:$B$65536=$B3)*(C$104:C$65536))
On Thu, May 3, 2012 at 12:11 PM, Darwin Chan darwin.chankaw...@gmail.comwrote:
Dear all,
Hi seema
long time back I created this addin to search on Google . I am not
sure how much accurate result will it give now . you can try it and
make changes in the code as per your requirement.
Download Link http://www.box.com/s/ab954ee4970bae3bf815
(File is too heavy so i have uploaded it on
For deleting all files from a folder..
Sub deleteFiles()
Dim MyFile As File
Dim MyFolder As Folder
Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject
Set MyFolder = fso.GetFolder(YourFolderPath)
For Each MyFile In MyFolder.Files
into a regular module. Change the date, folder, as I
said.. It’s automatic based on the date.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Mr excel excelkeec...@gmail.com
*Sent:* Wednesday, January 25, 2012 6:51 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros
, 2012 6:51 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
thanks a lot guillet for your support.i would further like to know
whether this code works simply by installing it in the code window of an
excel sheet and triggers itself
on the date.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Mr excel excelkeec...@gmail.com
*Sent:* Wednesday, January 25, 2012 6:51 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
thanks a lot guillet for your support.i
If placed in the Thisworkbook module in the workbook_open event it will fire
when you open the workbook.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mr excel
Sent: Friday, January 27, 2012 6:05 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Code for deleting
VBA Should do it. Change date and folder and file type to suit.
Sub DeleteFilesIfDay()
If Date = DateValue(1/25/2012) Then
On Error Resume Next
Kill C:\yourfoldernamehere\*.*
On Error GoTo 0
End If
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mr excel
Sent: Wednesday,
thanks a lot guillet for your support.i would further like to know whether
this code works simply by installing it in the code window of an excel
sheet and triggers itself on that particular date (checking the date with
the system date). Tell me how to get this code work with out any problems.
Just copy into a regular module. Change the date, folder, as I said.. It’s
automatic based on the date.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mr excel
Sent: Wednesday, January 25, 2012 6:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Code
excelkeec...@gmail.com
*Sent:* Wednesday, January 25, 2012 6:51 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
thanks a lot guillet for your support.i would further like to know whether
this code works simply by installing it in the code
Try this :
=REPLACE(REPLACE(A1,3,2,.),6,5,.)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: Jan/Thu/2012 09:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ code
I want to change this column A to column G (means I
@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Thursday, January 19, 2012 8:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ code
Dear Muneer,
You can use finally this formula in G1
=LEFT(A1,2).MID(A1,5,3).RIGHT(A1,1)
hope it help
, 2012 8:41 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ code
** **
Dear Muneer,
You can use finally this formula in G1
=LEFT(A1,2).MID(A1,5,3).RIGHT(A1,1)
hope it help to you..
otherwise i wll send you macro(VBA Code)..
See attached sheet.
--
Thanks
Dear Santosh,
Please see attached sheet i hope it will help to you.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Nov 28, 2011 at 3:00 PM, santosh
A TEXT can never be lesser than a number. At least in the Excel world.
Santhosh, please replace the entire code in form1 with this
Private Sub CommandButton1_Click()
If CDate(TextBox1.Value) Date Then
msg = MsgBox(You cannot make a transaction for a future date,
vbCritical, Your
thank you all very muchh
On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV venkat1@gmail.com wrote:
Hi Bheema,
See below image and Try Data Validation and use custom and formula as *
=COUNTIF(C:C,C1)=1*
[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in
Use COUNTIF to check filenumber is unique :
=COUNTIF(the filenumber column,filenumber)=0
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bheema Shankar
Envoyé : mardi 6 septembre 2011 16:40
À : MS EXCEL AND VBA MACROS
Dear Bheema,
Please see attached Sheet...
On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar shankar.n...@gmail.comwrote:
I made a userform. linked it with the datasheet. the filenumber acts
as a bridge between userform and datasheet. I have to make the file
number unique in excel.
Hi Bheema,
See below image and Try Data Validation and use custom and formula as *
=COUNTIF(C:C,C1)=1*
[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar
How about a formula
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 8:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ code for search
Hai all good evening
I am
not working. and where to put this code. I made it on userform not on
sheet. So in your formula there is no representation of the objects na. how
it works ?
On Wed, Sep 7, 2011 at 7:20 PM, dguillett1 dguille...@gmail.com wrote:
How about a formula
I’m one of those people who doesn’t much care for pivot tables and userforms.
KISS (Keep it simple, stupid). Not meant personally.
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ code for search
not working
*Sent:* Wednesday, September 07, 2011 9:04 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ code for search
not working. and where to put this code. I made it on userform not on
sheet. So in your formula there is no representation of the objects na. how
it works
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled
1 to X to Word.
Date: Mon, 8 Aug 2011 14:40:00 -0500
What do you need to do in Word that you can't do in excel?
-Original Message-
From: skyping1
Sent: Monday, August 08, 2011 12:07
Anyone have any ideas on this please?
On Aug 3, 9:50 pm, Kevin gray kevinrobertg...@hotmail.com wrote:
Please see attachments
Date: Wed, 3 Aug 2011 07:48:44 +0530
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled
1 to X to Word.
From: venkat1@gmail.com
What do you need to do in Word that you can't do in excel?
-Original Message-
From: skyping1
Sent: Monday, August 08, 2011 12:07 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets
labelled 1 to X to Word.
Anyone have any ideas
Please Attached a sample file
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of skyping1
Sent: Tuesday, August 02, 2011 12:07 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled
Please find attached files...hope you can help
On Aug 2, 10:23 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Please Attached a sample file
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of skyping1
Sent: Tuesday,
Please see the following link, as I cant seem to upload files to this
site:
http://www.excelforum.com/excel-programming/784924-export-all-worksheets-in-order-to-word-including-pictures-etc.html
Thanks!
On Aug 2, 10:23 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Please Attached a sample
Hi
There is No attachment.
*Best Regards,*
*Venkat*
*Chennai*
On Tue, Aug 2, 2011 at 10:41 PM, skyping1 kevinrobertg...@hotmail.comwrote:
Please find attached files...hope you can help
On Aug 2, 10:23 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Please Attached a sample file
can you attach any workbook and word document how you will like the output
to be
On Tue, Aug 2, 2011 at 12:06 AM, skyping1 kevinrobertg...@hotmail.comwrote:
I have many Excel files in a folder which all have labelled Worksheets
from 1 to X where X is always an integer.
Most of the files have
The data actually pouplates till AS column.When the report is generated it
stops at cloumn AL.
Does this array thing has to do anything about it?
Application.StatusBar = Please Wait.Loading Trim(Prod) Data
File
Workbooks.OpenText FileName:=FileLoc, Origin _
:=xlWindows,
excel is opening a text File
the array are data for column index and length of string string to be
converted to a cells
Array(Array(1, 2), Array(2, 4))
text file contents: ABCDEFG
converted to 2 columns
column 1 = AB
column 2 = CDEF
If you use [Text To Column] ( of DATA menu) you will
: Re: $$Excel-Macros$$ CODE DOESN'T WORK
thanks Daniel Ji for the reply... here what I need and what the code doesn't
do.
This code runs as long as the Sheets(1).Cells(2, ColNumber) =
Sheets(Name).Cells(RowCounter, 1) but doesn't do the job. I have some data
with a lot of variables in sheet 1
@googlegroups.com
Sent: Mon, February 21, 2011 10:40:31 AM
Subject: RE: $$Excel-Macros$$ CODE DOESN'T WORK
The code is correct. Simply, there is no match and the test is always false.
Can
you post your data ?
Daniel
De :excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la
*To:* excel-macros@googlegroups.com
*Sent:* Mon, February 21, 2011 10:40:31 AM
*Subject:* RE: $$Excel-Macros$$ CODE DOESN'T WORK
The code is correct. Simply, there is no match and the test is always
false. Can you post your data ?
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel
Hi Mithlesh,
Thanks for sending formula..it solve my problem..
Regards
Nikhil
On Mon, Aug 9, 2010 at 12:15 AM, Mithlesh Sharma mtshar...@gmail.comwrote:
Hi Nikhil,
Try this one, will give result in VPS.
Vishal Pravinchandra Shah
=LEFT(A1,1)MID(A1,FIND( ,A1,1)+1,1)MID(A1,SEARCH(
Hi Nikhil
Insert this code in a standard module
Function FirstLetters(rng As Range) As String
Dim arrWords
Dim I As Long
arrWords = Split(rng, )
If IsArray(arrWords) Then
For I = LBound(arrWords) To UBound(arrWords)
FirstLetters = FirstLetters Left(arrWords(I), 1)
Attached is the spread sheet. Please do the needful.
On Fri, Mar 26, 2010 at 12:49 PM, Puttu puttu...@gmail.com wrote:
Hi Group,
I have sheet where I get a details of the company in different format,
which the output need in one excel row.
Example
Jamrut Trading Co. Send Mail
GREAT ANKUR
On Sat, Jan 9, 2010 at 10:32 AM, ankur ankurpande...@gmail.com wrote:
hi ramesh
please check this file
On 1/8/10, Chanti-Hyderabad ramesh1...@gmail.com wrote:
Hi Ankur,
That working file looks awesomebut i cant see see any data on 'New
Data' sheet. Is there a way i
Hi Ankur,
That working file looks awesomebut i cant see see any data on 'New
Data' sheet. Is there a way i can see the data change according to my
requirement?
Thanks in Advance,
Ramesh
On Jan 7, 4:33 pm, ankur ankurpande...@gmail.com wrote:
hi sumit
please check the attached file
if
Dear Madhu
This Sheet Not A Formulas V Lookup Ok
On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote:
Hi SUmit,
I added Vlookup, i think thats what you need, check attached sheet,
On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear,
I Make
hi sumit
please tell me your requiremnet
On 1/7/10, SUMIT VYAS svyas0...@gmail.com wrote:
Dear Madhu
This Sheet Not A Formulas V Lookup Ok
On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote:
Hi SUmit,
I added Vlookup, i think thats what you need, check attached
Dear Ankur,
Thanks For Your Reply
I want Make Excel Advance Lavel
I show Code
But I Hide Code This List No Report Gen rate
I want Milty User Working This Excel Report Gen rate One Time .
On Thu, Jan 7, 2010 at 11:47 AM, ankur ankurpande...@gmail.com wrote:
hi sumit
please tell me your
73 matches
Mail list logo