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

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

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

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

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

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

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

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

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

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.

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,

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.

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

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.

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,

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 A to column G (means

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

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

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 Obje

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

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 wrote: > How about a formula > > =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E

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 a

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.

Hi There is No attachment. *Best Regards,* *Venkat* *Chennai* On Tue, Aug 2, 2011 at 10:41 PM, skyping1 wrote: > Please find attached files...hope you can help > > On Aug 2, 10:23 am, "Rajan_Verma" wrote: > > Please Attached a sample file > > > > > > > > > > > > > > > > -Original Mess

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

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" wrote: > Please Attached  a sample file > > > > > > > > ---

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

Please find attached files...hope you can help On Aug 2, 10:23 am, "Rajan_Verma" wrote: > 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

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

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

Hi, Try : Sub test2() Dim c With Sheets("calculator") On Error Resume Next For i = 1 To .Shapes.Count Var = .Shapes(i).OLEFormat.progID If Err.Number <> 0 Then Err.Clear Else If .Shapes(i).OLEFormat.progID = "Forms.TextBox.1" _

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

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

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

*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" of which I need few variable list

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

Wow! This works great. The advantage of not always having to specify the sheet when using Named Ranges never occurred to me. As for this line: c As Range I would have expected to see something like 'c As Cell', but I guess in Excel terms a cell is a range (albeit a very small one)? Thanks much.

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

Hi Kurt, If your named ranges are really called WS1Data, WS2Data, WS3Data, WS4Data, then your code can be reduced to just a few lines. Sub NoData() Dim i As Integer, c As Range ' Cycle thru each Named Range For i = 1 To 4 ' Cycle thru each cell within the Named Range

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

Re: $$Excel-Macros$$ Code Help

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(" ",A1,1)+1)+1,1) Regards, Mithlesh Sharma On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah wrote: > Hi Friends, > > In Column " A " .. I have written ---

Re: $$Excel-Macros$$ Code Help

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

Re: $$Excel-Macros$$ Code or Formula Required

Hi Group, Could you please help on this. Thanks Puttu On Fri, Mar 26, 2010 at 3:44 PM, Puttaswamy wrote: > Attached is the spread sheet. Please do the needful. > > > On Fri, Mar 26, 2010 at 12:49 PM, Puttu wrote: > >> Hi Group, >> >> I have sheet where I get a details of the company in differ

Re: $$Excel-Macros$$ Code or Formula Required

Attached is the spread sheet. Please do the needful. On Fri, Mar 26, 2010 at 12:49 PM, Puttu 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 > > Busin

Re: $$Excel-Macros$$ Code User Laval

GREAT ANKUR On Sat, Jan 9, 2010 at 10:32 AM, ankur wrote: > hi ramesh > > please check this file > > > On 1/8/10, Chanti-Hyderabad wrote: > > 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 accord

Re: $$Excel-Macros$$ Code User Laval

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 wrote: > hi sumit > > please check the attached file > > if any other modificati

Re: $$Excel-Macros$$ Code User Laval

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 wrote: > hi sumit > please tell me your requiremnet > > On 1/7

Re: $$Excel-Macros$$ Code User Laval

hi sumit please tell me your requiremnet On 1/7/10, SUMIT VYAS wrote: > Dear Madhu > > This Sheet Not A Formulas V Lookup Ok > > > > > On Wed, Jan 6, 2010 at 8:17 PM, madhu nair wrote: > >> Hi SUmit, >> >> I added Vlookup, i think thats what you need, check attached sheet, >> >> On Wed, Jan 6,

Re: $$Excel-Macros$$ Code User Laval

Dear Madhu This Sheet Not A Formulas V Lookup Ok On Wed, Jan 6, 2010 at 8:17 PM, madhu nair 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 wrote: > >> Dear, >> >> I Make Some Excel Code User Lavel Se