Re: $$Excel-Macros$$ CODE FOR RANGE

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,

Re: $$Excel-Macros$$ CODE FOR RANGE

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

$$Excel-Macros$$ CODE FOR RANGE

If I change the location of the data as shown in A12:B16, then where should I change the code, please do the needful -- 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/discussexc

$$Excel-Macros$$ Code to show how to insert an in-cell drop down calculator and insert value of calculation

I saw a custom calculator made by a google group user years ago. It was an excel group. Can I only assume this task would require a custom made calculator form? If there is a built-in windows calculator/API, would that be something to use instead? Basically, I am wondering what the code would b

Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

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 title

Re: $$Excel-Macros$$ code requried

first No I have not done vba programming before secondly the destination workbook will be new, there is no datasheet in it, just blank sheets as usual, third Yes I'm taking the data from the source workbook to the destination workbook. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ code requried

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 dat

$$Excel-Macros$$ code requried

HI I need code for a workbook in which I want to take four sheets from another workbook MORE EXPLANATION If I've a workbook namely "A", in this workbook I've different sheets having names like jan, feb, mar etc etc i need another workbook with four months data from "A" -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Code in Workbook_Open macro inadvertently crashes the file!!!

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 Events_Disabled

$$Excel-Macros$$ Code in Workbook_Open macro inadvertently crashes the file!!!

Mayday MaydayI need help My workbook contains several sheets displaying various report forms. The content of each report is based on the selections made from a UserForm. On the Workbook_Open macro I have 'Call OpenUF1' code to open the UserForm. Sub OpenUF1() Load UserForm1 UserFo

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

absolutely perfect now. thanks a lot. :) :) Sent by Outlook for Android On Mon, Jul 27, 2015 at 5:27 AM -0700, "ashish koul" wrote: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Cells.Count = 1 Then If Target.Address = "$K$2"

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

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,

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

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 b

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

its perfect! thanks a lot... :) Sent by Outlook for Android On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul" wrote: use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh wrote: > > Dear

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh wrote: > > Dear Experts > > > > I wrote a code to multiply or divide a range of numbers by 1000 if > depending on whether a user selects a yes or no fr

$$Excel-Macros$$ Code Loops indefiniely due to cell value

Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell

Re: $$Excel-Macros$$ code vba pour une date automatique

thanks 2015-05-21 17:18 GMT+01:00 Mustapha LMIDMANI : > 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 : > >> thanks >> yes the problem is what you just said, each time you open the fi

Re: $$Excel-Macros$$ code vba pour une date automatique

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 : > 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

Re: $$Excel-Macros$$ code vba pour une date automatique

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: http://familycomputerclub.com/auomatic-date-tim

Re: $$Excel-Macros$$ code vba pour une date automatique

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 : > bonjour > je cherche un code vba qui affiche la date dans la cellul

$$Excel-Macros$$ code vba pour une date automatique

bonjour je cherche un code vba qui affiche la date dans la cellule e après qu'on a saisie les données dans le cellule a b c d et que cette date soit fixe et ne change pas avec le temps. merci pour l'aid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:

$$Excel-Macros$$ Code that passively identifies users who opened a workbook

I am trying to determine the code that would (passively) record the users, within our company, who are using a selected workbook. Is this feasible and if so how do I write it. Thank you, Rob -- 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) !

Re: $$Excel-Macros$$ Code needed that would rename same name sub-folders

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 fol

$$Excel-Macros$$ Code needed that would rename same name sub-folders

Hi, everyone, can you suggest a code that would help me find all sub-folders called "abc" and rename each to "1. abc"? -- 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/discus

Re: $$Excel-Macros$$ code required to clear active sheet.

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 wrote: > hi experts.. > > actually its not working... > > kindly help me on this...it clears only sheet 1 contents... if i select >

Re: $$Excel-Macros$$ code required to clear active sheet.

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 wrote: > hi experts, > > i got the answer for my late

Re: $$Excel-Macros$$ code required to clear active sheet.

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 wrote: > hi experts, > > what is the code to clear the contents including formats in active she

$$Excel-Macros$$ code required to clear active sheet.

hi experts, what is the code to clear the contents including formats in active sheet? if im in sheet 1and if i run the macro it should clear only the sheet 1 data, if i go to sheet to and if i run the macro it should clear only the sheet 2 data. please help. regards, prabhu r -- Are you =EXP

Re: $$Excel-Macros$$ Code Automatically

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 = ws.Cells(Columns.Count).End(xlToLef

Re: $$Excel-Macros$$ Code Automatically

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 val

Re: $$Excel-Macros$$ Code Automatically

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 wrote: > Can you also provide a sample output? > > > On Tue, Mar 1

Re: $$Excel-Macros$$ Code Automatically

Can you also provide a sample output? On Tue, Mar 12, 2013 at 11:37 AM, Chaya 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 solve the query.

Re: $$Excel-Macros$$ Code to refresh information from external data source

what is the source of external information On Thu, Nov 29, 2012 at 1:52 AM, Hilary Lomotey wrote: > Hello Expert > > can i get help with a code to refresh information coming from a data > source. i know the short cut ctrl + alt +f5 to refresh such data, but i > would be grateful to get a code to

$$Excel-Macros$$ Code to refresh information from external data source

Hello Expert can i get help with a code to refresh information coming from a data source. i know the short cut ctrl + alt +f5 to refresh such data, but i would be grateful to get a code to do that thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Code Problem

From: SAJID MEMON To: Sundarvelan Natarajan 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 p

Re: $$Excel-Macros$$ Code Problem

the address) and confirm. > > Regards, > Gawli Anil > > On Tue, Nov 13, 2012 at 2:50 PM, SAJID MEMON wrote: > >> I have shared it but it not open from other PC except main (Lenovo) >> >> >> ------ >> Subject: Re: $$Excel-Macro

Re: $$Excel-Macros$$ Code Problem

ovo) > > > -- > 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 > s

RE: $$Excel-Macros$$ Code Problem

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 be

Re: $$Excel-Macros$$ Code Problem

: 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\d\12-13\book1.xls or \\dell\d\12-13\book1

RE: $$Excel-Macros$$ Code Problem

from 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 pro

Re: $$Excel-Macros$$ Code Problem

At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: SAJID MEMON To: Sundarvelan Natarajan Sent: Mon, November 12, 2012 9:41:10 AM Subject: $$Excel-Macros$$ Code Problem ple

$$Excel-Macros$$ Code for combining PDF files thru VBA

Dear Team, Kindly help on Code for combining multiple PDF files thru VBA regards, Prashant -- -- FORUM RULES (986+ 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 A

Re: $$Excel-Macros$$ Code for range shifting based on month

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$65536wrote: > Dear all, > > I have a spreadsheet containing daily customer transaction data. I have > used SUMIF to find out the monthly customer transaction data. > However,

$$Excel-Macros$$ Code for range shifting based on month

Dear all, I have a spreadsheet containing daily customer transaction data. I have used SUMIF to find out the monthly customer transaction data. However, it is tedious to copy the formula and paste for next month when next month comes. Can anyone suggest any VBA code / idea to help shifting the

Re: $$Excel-Macros$$ Code for extracting google search results in excel

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

RE: $$Excel-Macros$$ Code for deleting files in a folder.

MyFile.Delete Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr excel Sent: Jan/Thu/2012 06:03 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Code for deleting files in a folder. hi all, i would like to know

Re: $$Excel-Macros$$ Code for deleting files in a folder.

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

Re: $$Excel-Macros$$ Code for deleting files in a folder.

guillett >>>> >>>> >>>> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 wrote: >>>> >>>>> Just copy into a regular module. Change the date, folder, as I >>>>> said.. It’s automatic based on the date. >>>>>

Re: $$Excel-Macros$$ Code for deleting files in a folder.

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$$ Cod

Re: $$Excel-Macros$$ Code for deleting files in a folder.

>>> 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 for deleting files in a folder. >

Re: $$Excel-Macros$$ Code for deleting files in a folder.

ange 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

Re: $$Excel-Macros$$ Code for deleting files in a folder.

From:* Mr excel > *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

Re: $$Excel-Macros$$ Code for deleting files in a folder.

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 for

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 that particular date (checking the date with the system date). Tell me how to get this code work with out any problems. Than

Re: $$Excel-Macros$$ Code for deleting files in a folder.

cel Sent: Wednesday, January 25, 2012 6:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Code for deleting files in a folder. hi all, i would like to know the code for deleting all the files in a folder on a desired day or say a particular date using vba or any script fo

$$Excel-Macros$$ Code for deleting files in a folder.

hi all, i would like to know the code for deleting all the files in a folder on a desired day or say a particular date using vba or any script for that matter.Can i achieve the same using DOS commands or any software is required to do. Kindly help. Regards excelkeechak. -- FORUM RULES (986

RE: $$Excel-Macros$$ 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

Re: $$Excel-Macros$$ code

excel-macros@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

RE: $$Excel-Macros$$ code

cros@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)&a

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

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

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

Dear Santosh, Please see attached sheet i hope it will help to you. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Nov 28, 2011 at 3:00 PM, santo

$$Excel-Macros$$ Code in the userform for date validation not working properly

Hi All, In the user form I have coded a date validation which should take data for current date or the previous date only with the help of *calendar only*. However, the code is not working properly. Moreover in the textbox3 I want it to restrict it only for numbers and no character should be all

$$Excel-Macros$$ Code request

Dear All May I get any expert attention for my problem with regard to the crystal report and excel vba userform. How to open a designed crystal report from the excel vba userform by a command button ? What I have to select from the check boxes in the reference option of Tools Menu of Excel vBA u

$$Excel-Macros$$ code to link report form to the userform

I am using crystal report 9 to make reports from excel data. How to access the report from the userform command button ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

thank you all very muchh On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV 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 profile

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

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 * * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Dear Bheema, Please see attached Sheet... On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > 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. Because the duplica

RE: $$Excel-Macros$$ Code to control the database not to accept repeated number

ACROS Objet : $$Excel-Macros$$ Code to control the database not to accept repeated number 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. Because the duplicate numbers also accepting b

Re: $$Excel-Macros$$ code for search

y, 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 ? &

Re: $$Excel-Macros$$ code for search

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. and

Re: $$Excel-Macros$$ code for search

,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 attaching the excel sheet whic

Re: $$Excel-Macros$$ code for search

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

$$Excel-Macros$$ code for search

Hai all good evening I am attaching the excel sheet which contains file numbers and names in corresponding file number. I placed an userform with file no. and name with a command button for search. If we know the name and dont know the file no. by giving little part of the name and if pressed on

$$Excel-Macros$$ Code to control the database not to accept repeated number

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. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solu

$$Excel-Macros$$ code for modify command button

I have a database in my excel. On userform i pasted a command button with the name UPDATE. on the click event, the data to the corresponding File no. will populate in respective textfields. My intention is to, if any modify in one or two textfields, when I click on the update button the same wil

RE: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

; To: excel-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- >

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

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 on

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

Anyone have any ideas on this please? On Aug 3, 9:50 pm, Kevin gray 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

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

> > > > > > > > > > > > -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

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

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 Tra

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

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 1 > to X to Word. > > I have many Excel files in a folder which all have labelled Worksheets > from 1 to

RE: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

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

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

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 wrote: > 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 about 10 worksheets, an

$$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

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 about 10 worksheets, and these can have both text and pictures in. I have searched, for some code (to no avail and through quite a few forums!!), that would copy

RE: $$Excel-Macros$$ code to clear all the values at a one go

Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de santosh subudhi Envoyé : mardi 5 avril 2011 23:31 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ code to clear all the values at a one go Hi Group, Need a code to clear the values of a

Re: $$Excel-Macros$$ code to clear all the values at a one go

Dear Santosh, Please find & see attached sheet, if it help.. -- Thanks & regards, Noorain Ansari On Wed, Apr 6, 2011 at 3:00 AM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > Need a code to clear the values of all the text boxes ,comboboxes in one > click in a excel

$$Excel-Macros$$ code to clear all the values at a one go

Hi Group, Need a code to clear the values of all the text boxes ,comboboxes in one click in a excel sheet with the name "calculator" -- Regards Santosh santoshkumar.subu...@gmail.com -- -- Some important links for

Re: $$Excel-Macros$$ code explanation please

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,

Re: $$Excel-Macros$$ code explanation please

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

$$Excel-Macros$$ code explanation please

What does the following code do?especially the array part! Application.StatusBar = "Please Wait.Loading " & Trim(Prod) & " Data File" Workbooks.OpenText FileName:=FileLoc, Origin _ :=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, Consecutiv

Re: $$Excel-Macros$$ CODE DOESN'T WORK

ou deleted column 1, then column 2 is now column 1. > you increment your counter and check column 2. > Which means that the "current" column 1 (formerly column 2) was never > checked. > If two adjacent columns happen to both have a "0", then you'll only delete > the fir

Re: $$Excel-Macros$$ CODE DOESN'T WORK

1 0 1 when column C is deleted, the loop then checks column D in the next iteration. When deleting rows or columns, I prefer to work "backwards", like: For ColNo = 750 To 1 Step -1     If Cells(1, ColNo).Value = 0 Then     Cells(1, ColNo).EntireColumn.Delete     End If Next hope this helps, Paul ___

RE: $$Excel-Macros$$ CODE DOESN'T WORK

: 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 da

Re: $$Excel-Macros$$ CODE DOESN'T WORK

What is not working ? Do you get an error ? > > What are you trying to do ? > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* rakesh kumar > *Envoyé :* dimanche 20 février 2011 11:16 > *À :* excel-macros@googlegrou

RE: $$Excel-Macros$$ CODE DOESN'T WORK

Hello, What is not working ? Do you get an error ? What are you trying to do ? Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de rakesh kumar Envoyé : dimanche 20 février 2011 11:16 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ CODE

RE: $$Excel-Macros$$ Code to enter value in multiple worksheets

nd not others. I use trial and error a lot. Regards - Dave. > Date: Fri, 27 Aug 2010 11:20:10 -0700 > Subject: Re: $$Excel-Macros$$ Code to enter value in multiple worksheets > From: heislerk...@gmail.com > To: excel-macros@googlegroups.com > > Wow! This works great. The advan

Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

bad practice to use a word like 'cell' as a > variable, since VBA has already allotted it a special meaning. VBA might pout > if you use its favourite words for other things. > > Hope this helps. > > Regards - Dave. > > > Date: Wed, 25 Aug 2010 12:14:21 -0700 >

RE: $$Excel-Macros$$ Code to enter value in multiple worksheets

quot;) By the way, note that I've used 'c' as my variable to represent each cell in the range. It's generally bad practice to use a word like 'cell' as a variable, since VBA has already allotted it a special meaning. VBA might pout if you use its favourite words for o

$$Excel-Macros$$ Code to enter value in multiple worksheets

I have 4 worksheets (WS1, WS2, etc.) with cells that get populated with data from a linked source sheet. In Column B on each worksheet is a dynamic range of cells (on WS1 it's "WS1Data," WS2 it's "WS2Data," etc.) When rows in the range are blank, I'd like to insert the word "no data." I can do thi

Re: $$Excel-Macros$$ Code Help

Hi Mithlesh, Thanks for sending formula..it solve my problem.. Regards Nikhil On Mon, Aug 9, 2010 at 12:15 AM, Mithlesh Sharma wrote: > 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(" ",A1,FIND(" > "

  1   2   >