Re: $$Excel-Macros$$ diff between two dates in no of years,months and days

Hi Abhishek Thanks a lot, this is the exactly whatI wanted... Thanks a lot once again. On Thu, May 26, 2016 at 6:35 PM, Abhishek Jain <abhishek@gmail.com> wrote: > Plz see attached > > On Thu, May 26, 2016 at 5:26 PM, Vaibhav Joshi <vaibhav...@gmail.com> > wrote: &

$$Excel-Macros$$ diff between two dates in no of years,months and days

s-3 Months-6 & 0 days ) Specimen file is enclosed for your reference. Regards Vaibhav Joshi -- 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

Re: $$Excel-Macros$$ Random Time Problem

put this formula in I2 & drag down: =IF(COUNTIF($B$2:B2,B2)=1,RANDBETWEEN(420,480)/1440,RANDBETWEEN(I1*1440+TIME(0,31,0)*1440,I1*1440+TIME(0,55,0)*1440)/1440) Cheers!! On Wed, Nov 25, 2015 at 1:44 AM, Bill Q wrote: > > > I gave this my best shot - but I am not satisfied

Re: $$Excel-Macros$$ BeforeSave not working

was macro was enabled on your system? On Tue, May 5, 2015 at 1:14 AM, mburkett michaelburk...@gmail.com wrote: One more oddity. I opened the file on another computer on our network and it worked perfectly. Both have the same rights so there must be some setting within Excel? Ideas? On

Re: $$Excel-Macros$$ formula required

Author need formula i guess this is already answered for similar question.. On Sun, May 3, 2015 at 7:37 PM, Rajesh Agarwal rajey...@gmail.com wrote: please provide me the formula. -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Exact Search excluding fractions

when you do filter, in criterion put is equal to... also when you do search thru Control plus f ( ctr + f) click on options tick on match entire cell content .. On Sat, May 2, 2015 at 12:52 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, I am trying to use (SEARCH and Vlookup)

Re: $$Excel-Macros$$ BeforeSave not working

Change 1st line to.. Private Sub Workbook_BeforeClose(Cancel As Boolean) Cheers!! On Mon, May 4, 2015 at 10:32 PM, mburkett michaelburk...@gmail.com wrote: I have some very simple code that I put in the workbook's BeforeSave event. When I click save the code doesn't run. Any ideas? I've

Re: $$Excel-Macros$$ Re: Query to retreive data

you dont need access, you can continue using excel thru DAO you can retrieve data from closed workbook too.. On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh nasirsa...@gmail.com wrote: r8 Pramod access is very easy and taking very less time than excel on huge data you can use it till 2 GB data.

Re: $$Excel-Macros$$ Query to retreive data

Which version of excel you are using? Are both file on same machine or they are on Network? On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja rockerna...@gmail.com wrote: My mmaster file is large and i just want to do lookup on my sheet from master file without opening my master file as it is

Re: $$Excel-Macros$$ Loop in filtered value by VBA

hi What do you mean by when sometime no record of LF found then other data past on state sheet with error?? You mean no additional data found ? On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Dear Team, i have read this type query on many sites but not

Re: $$Excel-Macros$$ Want to Close file in second if not in use.

Check this.. http://www.ozgrid.com/forum/showthread.php?t=66164 On Thu, Apr 16, 2015 at 5:43 PM, Nasir Saikh nasirsa...@gmail.com wrote: Hi Guys, Please help i am stuck on a code that if nodbody is using excel then the current workbook should close in 10 second with popup of

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

Check this... Add two helper column see formula in Green, i have tested for both of sample data given by you its working.. Cheers!! On Tue, Apr 14, 2015 at 5:39 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello Mandeep, Formula does not work when Column B is General Field(Mix

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Janaki welcome to Excel Macros.. If you have any query start separate thread.. Cheers!! On Sat, Apr 11, 2015 at 4:46 PM, Janaki Dalvi janaki.dal...@gmail.com wrote: Thanks Ayush for giving us this forum, Have been through some of the posts and it has been a lot of help thus far. To

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

check sheet after updating formula... On Wed, Apr 1, 2015 at 12:49 PM, Vaibhav Joshi v...@vabs.in wrote: HI Note cell range dollar sign, it is $B$1:$B1$B$2:$B2 On Tue, Mar 31, 2015 at 10:42 PM, bobengler bobeng...@bellsouth.net wrote: Here is a test of after I added the 2 rules. Can

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

HI Note cell range dollar sign, it is $B$1:$B1$B$2:$B2 On Tue, Mar 31, 2015 at 10:42 PM, bobengler bobeng...@bellsouth.net wrote: Here is a test of after I added the 2 rules. Can you see if I missed a step? Thanks, Bob -- *From:* Vaibhav Joshi v

Re: $$Excel-Macros$$ Macro to copy outlook mail

check this... On Wed, Apr 1, 2015 at 8:45 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Experts, Any update on my below query.. On 31-Mar-2015 5:45 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi experts, Please share vba code to copy outlook mails subject name, sender name, Date

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

-- *From:* Vaibhav Joshi v...@vabs.in *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Wednesday, April 1, 2015 3:20 AM *Subject:* Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value check

Re: $$Excel-Macros$$ Formula required

Check this... On Tue, Mar 31, 2015 at 12:43 PM, Dhaval Shah todhavals...@gmail.com wrote: PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

Hi Bob, Check attachment, Copy formula from G2 Select A2 to D12 ( or larger range) goto conditional formatting, select manage rules select new rule, after that select use formula to determine which cells to format..paste formula, click format select color you want to give... After that Copy

Re: $$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

character which you see may not be the same which you type, press F2 copy characters then you can do Find replace copied character with unique character like underscore or so after that goto data text to column.. On Tue, Mar 31, 2015 at 12:22 AM, Bill Q ronsmith...@gmail.com wrote: Thanks,

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

and most of the field 2s are non repeating. Thank you, Bob Engler -- *From:* Vaibhav Joshi v...@vabs.in *To:* excel-macros@googlegroups.com *Sent:* Tuesday, December 23, 2014 10:44 AM *Subject:* Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end

Re: $$Excel-Macros$$ Re: Do you want to marry? View Similar Profiles.

Hi This is pertaining to Group Important Jobs Walkin Updates, i haven't recd any such emails from Excel VBA Group.. On Mon, Mar 30, 2015 at 1:09 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Why this kind of mails in this group??? On 30-Mar-2015 1:00 PM, Sajini join.m...@gmail.com wrote:

Re: $$Excel-Macros$$ Copy Data from another application to excel.

hi without any application in front coding can not be set for 3rd party app.. On Fri, Mar 27, 2015 at 2:17 AM, Avinash avinash007pa...@gmail.com wrote: Hi Experts, i want a macro which can copy data from another application to excel. below is the code which i am trying to use. i dont have

Re: $$Excel-Macros$$ Begin a Group in vba custom toolbar

Check this for help.. http://www.vbaexpress.com/kb/getarticle.php?kb_id=427 On Sun, Mar 22, 2015 at 4:33 PM, Don Bowyer dwbowye...@gmail.com wrote: In Excel 2003 on Windows 7 I have created a custom toolbar using VBA. The toolbar has about 7 buttons each of which activates a separate

Re: $$Excel-Macros$$ Retrieve data thru VBA Macro..

Hi There are many ways to do it, few are: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html http://support.microsoft.com/en-us/kb/214270 http://www.bighungrygeek.com/merge-worksheets-in-excel/ http://www.rondebruin.nl/win/addins/rdbmerge.htm Cheers!! On Mon, Mar

Re: $$Excel-Macros$$ Re: Find Second Highest value from data

Try this for finding 2nd largest value, this works even if you have zeros duplicate nos in range, its array formula... =MAX(IF(A1:A10MAX(A1:A10),A1:A10)) Cheers!! On Fri, Mar 27, 2015 at 12:34 PM, Pramod Singh pramod...@gmail.com wrote: Hi All. Good question came from amit. Excel expert.

Re: $$Excel-Macros$$ Look formula required

Hi You can use simple vlookup formula, but you need to reverse the table, check attachment formula is in col G. Cheers!! On Fri, Mar 27, 2015 at 11:41 AM, Rajesh thrissur rajeshkainikk...@gmail.com wrote: Hi Experts please check the attached table , there i have to select a value from one

Re: $$Excel-Macros$$ Find Second Highest value from data

try this... On Fri, Mar 27, 2015 at 12:55 PM, Mandeep Baluja rockerna...@gmail.com wrote: put this formula in h2 it will give you large from alternate columns =LARGE(IF(MOD(COLUMN(A2:G2),2)0,A2:G2),2) Press control+ shift +enter to create array formula. Regards, Mandeep On Friday,

Re: $$Excel-Macros$$ Need some formula or MACROS

Your first rule works fine, you can add 2nd rule via conditional formatting mange rule.. check this file i have added rule for your reference. Cheers!! On Fri, Mar 27, 2015 at 8:34 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Dear Team, i need to

Re: $$Excel-Macros$$ Query for If condition or VBA

can you explain one example.. On Wed, Mar 25, 2015 at 1:45 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello, Please solve this query!!! -- Thanks Regards *Sunil Kumar Yadav* * Sr. Executive - *MIS (Billing Deptt.) Skype ID: sunil.yadav7186 On Tue, Mar 24, 2015 at 5:27 PM,

Re: $$Excel-Macros$$ Query for If condition or VBA

check formula in col E, If there are more than 2 case of overlap then 1st will be shown as ok second will be as error. In case it is more than 2 case of overlap then 1st will be shown as ok rest all will be shown as error.. Cheers!! On Wed, Mar 25, 2015 at 2:01 PM, Vaibhav Joshi v...@vabs.in

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

code to avoid error on path not written in cell. but though same error is occur, pls do something in coding. If ws.Range(F2) Chr(48) Then .addattachment rngAttach1.Value End If On Mon, Mar 23, 2015 at 6:30 PM, Vaibhav Joshi v...@vabs.in wrote: Before adding att check

Re: $$Excel-Macros$$ Database for concert ticket sales

Hi can you share website link? On Sat, Mar 21, 2015 at 10:48 PM, ldenholl l.denh...@gmail.com wrote: Hi all, I'm an intermediate Excel/Access user and have an inquiry for you all. You know how when you buy tickets for a big event online and you can select which seats you want in the

Re: $$Excel-Macros$$ Re: How to declare public array

Check this for an alternate way... If you wan all code to remained in Sheet module then you can take only Public variable in separate Module. Cheers!! On Wed, Mar 25, 2015 at 4:48 PM, Vaibhav Joshi v...@vabs.in wrote: Hi your method is correct, only error you did is u showed it in worksheet

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 4 updates in 3 topics

=digestutm_medium=email Vaibhav Joshi v...@vabs.in: Mar 23 06:30PM +0530 Before adding att check if attachment exists or not, if its null then you will get error... Cheers!! On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: ...more http://groups.google.com

Re: $$Excel-Macros$$ How to declare public array

Try this: Option Explicit Dim myarray(1) As Variant Sub PublicArrayExample() 'Dim myarray(2) As String 'Fill the array MyArray with values. myarray(0) = Hello myarray(1) = Goodbye 'Run the TestPublicArrayExample macro to display MyArray. Call TestPublicArrayExample End Sub Sub

Re: $$Excel-Macros$$ Re: How to declare public array

Hi your method is correct, only error you did is u showed it in worksheet module (which is pvt module by default), you need to create separate module and add code in to it.. See attachment. Cheers!! On Wed, Mar 25, 2015 at 4:19 PM, Rohit Jadhav rohitj...@gmail.com wrote: Thanks a lot. It

Re: $$Excel-Macros$$ Who is admin for this group?

Ayush Jain is Group Manager you can contact him. On Tue, Mar 24, 2015, 9:24 PM Prabhu Pinky prabhupin...@gmail.com wrote: Hi, anyone please let me know who is the admin for this group. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

Before adding att check if attachment exists or not, if its null then you will get error... Cheers!! On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, See the attached file of email sending from excel. Normally mail send successfully to all

Re: $$Excel-Macros$$ Macro to Copy Active Sheet

Try This: Sub CopyRename() Dim sName As String Dim wks As Worksheet 'Worksheets(Master).Copy after:=Sheets(Worksheets.Count) ActiveSheet.Copy after:=Sheets(Worksheets.Count) Set wks = ActiveSheet sName = Application.InputBox _ (Prompt:=Enter new worksheet name)

Re: $$Excel-Macros$$ Macro to Copy Active Sheet

Great Cheers!! On Thu, Mar 19, 2015, 7:34 PM Stephen E. Hale theultraph...@gmail.com wrote: Thank you so much Vabz, that is just what i was looking for. I really appreciate you help. On Thursday, March 19, 2015 at 1:30:02 AM UTC-7, Vabz wrote: Try This: Sub CopyRename() Dim sName As

Re: $$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column

Check this... Cheers!! On Tue, Mar 17, 2015 at 11:35 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I have an excel format 2007 for daily data entry, as attached. I used to select Party Names through drop down list in column F and need to type the invoice numbers in cloumn E based on the

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

Try this macro: https://sites.google.com/site/thexlwiz/files/SaveDBF.zip?attredirects=0 On Tue, Mar 17, 2015 at 12:22 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello, Can anyone help me to modify save DBF files in Excel 2007. Pravin. On Saturday, March 14, 2015 at 1:01:39 PM

Re: $$Excel-Macros$$ Query for autofit columns.

Check this.. Cheers!! On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Quuery for autofit -- 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 @

Re: $$Excel-Macros$$ Help in Vlook-up or any other formula

Cheers!! On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Dear Vaibhav, Thank you very much for your quick support. This is very helpful. Regards, Vijayendra 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi v...@vabs.in: PFA with #N/A handler... On Fri, Mar 13

Re: $$Excel-Macros$$ Re: Help with combination formula

Hi Mandeep, Logic used in macro is rilli cool... Cheers!! On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday, 14 March 2015 15:06:13

Re: $$Excel-Macros$$ Re: Help with combination formula

Hey Will Check this attachment..in any of given columns it will check occurrence of 10 , 13 17 in any order... Hope you like it,.,. Cheers!! On Mon, Mar 16, 2015 at 5:34 PM, Will Sob will00...@gmail.com wrote: Gosh l like this method thanks a lot. This is the best l have seen most

Re: $$Excel-Macros$$ Formula based on some criteria

Hi Check col D for solution.. Cheers!! On Sun, Mar 15, 2015 at 10:23 AM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Team, Can any one help on this. Thanks, Rameshwari -- Forwarded message -- From: rameshwari shyam rameshwarish...@gmail.com Date: Fri, Mar

Re: $$Excel-Macros$$ Sum value of closing balance of date

Hi Use this array formula =SUM(IF(A3:A17A2:A16,D2:D16,0)) Cheers!! On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara

Re: $$Excel-Macros$$ Sum value of closing balance of date

Hi Check cell D20 for formula.. On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Use this array formula =SUM(IF(A3:A17A2:A16,D2:D16,0)) Cheers!! On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need function

Re: $$Excel-Macros$$ Sum value of closing balance of date

, Vaibhav Joshi v...@vabs.in wrote: Hi Check cell D20 for formula.. On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Use this array formula =SUM(IF(A3:A17A2:A16,D2:D16,0)) Cheers!! On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote

Re: $$Excel-Macros$$ Help in Vlook-up or any other formula

check this.. Cheers!! On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Dear Experts, Can you please help me to put vlookup or any other formula for the the second row. Attached is the my file and request you to help on the same. Regards, Vijayendra 94491

Re: $$Excel-Macros$$ Help in Vlook-up or any other formula

PFA with #N/A handler... On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Dear Experts, Can you please help me to put vlookup or any other formula for the the second row. Attached is the my file and request you to help on the same. Regards, Vijayendra 94491

Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

Check formula in col k.. Cheers!! On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila andredavila...@gmail.com wrote: Dear experts, I can't figure out how to create a fórmula to this problem. In the first hand seems simples, but i couldn't sove without creating a excel macro. Is it possible

Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

You can also try this non array formula.. =INDEX(C4:I4,MATCH(TRUE,INDEX((C4:I40),0),0)) Cheers!! On Fri, Mar 13, 2015 at 8:49 PM, André D'Avila andredavila...@gmail.com wrote: Thank you very much André Luiz D´Avila 2015-03-13 12:13 GMT-03:00 Vaibhav Joshi v...@vabs.in: Check formula

Re: $$Excel-Macros$$ Please help me Urgent

Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9, you will get result in curly bracket, after = sign enter CONCATENATE( press enter to get result

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

: I need to colorize with vbblue, the background of cell Item 3 of column DUE, not the color font of cell (i know the way to do it). 2015-03-09 12:27 GMT+01:00 Vaibhav Joshi v...@vabs.in: Hi can you share sample data with userform for more clarity?? On Mon, Mar 9, 2015 at 4:26 PM, Sal Sal

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

Also this link is also working... http://www.excelforum.com/excel-programming-vba-macros/335820-listview-and-colored-line.html also check attachment.. On Tue, Mar 10, 2015 at 5:13 PM, Vaibhav Joshi v...@vabs.in wrote: check this http://vbnet.mvps.org/index.html?code/comctl/lvledger.htm

Re: $$Excel-Macros$$ Mail from excel using gmail

it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Mar 9, 2015 at 12:59 PM, Vaibhav Joshi v...@vabs.in wrote: Hi The script which you gave is using CDO for that you need to have SMTP services running on your machine through which you are running macro...check whether

Re: $$Excel-Macros$$ Update the Data from Different Sheet one below the another

Hi Refer this: https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx On Mon, Mar 9, 2015 at 4:36 PM, divya karkera sweetgrld...@gmail.com wrote: Dear Experts, I am held up with the small problem facing with my excel project. I need to update the Data from different sheets

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

11:23 Vaibhav Joshi v...@vabs.in ha scritto: Hi You can use Range.Interior.ColorIndex property.. e.g. Range(A1).Interior.ColorIndex = 5 On Sun, Mar 8, 2015 at 11:21 AM, Sal Sal sal72...@gmail.com wrote: Bug* but Il 07/mar/2015 17:09 Sal Sal sal72...@gmail.com ha scritto: Simply

Re: $$Excel-Macros$$ Re: Excel Macro to send email.. on specific dates of the month

Ok, from where you are fetching Line1, Line2 etc..? On Sun, Mar 8, 2015 at 5:10 AM, AndyB anindya20042...@gmail.com wrote: Hi Vabz Nope, grateful if you can help me. On Tuesday, 3 March 2015 20:32:36 UTC, AndyB wrote: Hi everyone, Hope you're well. Looking for some help with an email

Re: $$Excel-Macros$$ Mail from excel using gmail

in website. Kindly solve my query by either send using gmail or add connection of gmail in outlook. Thanks. On 07-Mar-2015 6:49 PM, Vaibhav Joshi v...@vabs.in wrote: Hi change port no. to 465 also you need to enable smpt / imap services for your Google account Cheers On Mar 7, 2015 5:48 PM, Ashish

Re: $$Excel-Macros$$ PLS SOLVE

Check this: http://www.exceltrick.com/how_to/sum-cells-based-on-background-color/ cheers!! On Mon, Mar 9, 2015 at 10:05 AM, sush.dav...@gmail.com wrote: -- 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

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

Use above code in conjunction with auto-filter code. On Sun, Mar 8, 2015 at 4:22 PM, Eugene Bernard eugene.bern...@gmail.com wrote: Dear Vaibhav, When I hit the button, I am getting the below error. [image: Inline image 1] Regards Eugene On Sat, Mar 7, 2015 at 4:00 PM, Vaibhav Joshi v

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

. Naturally the cell is in un a userform listview. Note: Not the colorfont bug the background color. Il 07/mar/2015 10:21 Vaibhav Joshi v...@vabs.in ha scritto: Can you explain with example through excel workbook? On Fri, Mar 6, 2015 at 1:46 AM, Sal Sal sal72...@gmail.com wrote: I know

Re: $$Excel-Macros$$ Need macro help

Hi I have already shared one macro with file name Macro import data from multiple files - 2 one sheets in this group. Cheers!! On Thu, Mar 5, 2015 at 9:59 PM, Paul Schreiner schreiner_p...@att.net wrote: Are the file names always the same? or do they change when they are updated? Do you

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

Can you explain with example through excel workbook? On Fri, Mar 6, 2015 at 1:46 AM, Sal Sal sal72...@gmail.com wrote: I know the way to colorize a font in a vba for excel listview but to colorize the background of cell in a listview? For example the cell in row 3, column 4?? --

Re: $$Excel-Macros$$ Help Required on Conditional Formating

Do let us know if you need any help.. Cheers!! On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Thanks On 7 Mar 2015 14:46, Vaibhav Joshi v...@vabs.in wrote: Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015

Re: $$Excel-Macros$$ Excel Macro to send email.. on specific dates of the month

Hi Andy Is it solved? On Wed, Mar 4, 2015 at 2:02 AM, AndyB anindya20042...@gmail.com wrote: Hi everyone, Hope you're well. Looking for some help with an email macro. So I have an excel sheet (similar copy attached). Once run, the macro should read from (the first sheet) Data - Column I

Re: $$Excel-Macros$$ Excel VBA Example

Its really good!! Cheers!! On Tue, Mar 3, 2015 at 8:02 AM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Hi Friends, Find attached some examples of VBA Macro *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES,

Re: $$Excel-Macros$$ Mail from excel using gmail

Hi change port no. to 465 also you need to enable smpt / imap services for your Google account Cheers On Mar 7, 2015 5:48 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want mail from excel using gmail ID. I want to mail from data sheet by filtering data of mail

Re: $$Excel-Macros$$ Help Required on Conditional Formating

Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Dear Friedns, Kindly help me in creating a conditional formating calander just like goole calander. My basis needs are as follows:-

Re: $$Excel-Macros$$ Load ListBox

@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi *Sent:* 2 martie 2015 12:23 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Load ListBox Hi Goto Name Manager select LIST press edit there after change refers to address .. Cheers

Re: $$Excel-Macros$$ Outlook VBA code to send email notification on a specific date criteria

Hi check this : http://superuser.com/questions/635094/scheduled-and-recurring-email-in-outlook http://www.mrexcel.com/forum/excel-questions/731321-run-outlook-visual-basic-applications-macro-specific-time-day.html Cheers!! On Wed, Mar 4, 2015 at 5:34 PM, sharath chandra

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

Check this.. Cheers!! On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Eugene, PFA, Filter your data then after hit the button Regards Ashish -- 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

Re: $$Excel-Macros$$ Re: Excel VBA to hide sheets of a workbook closes others too

Create new excel file with 3-5 sheets do same switching which you mentioned in your email... If this happens then you must have save above macro in personal.xlsb file which will be working on all workbook rather on specific workbook. cheers!! On Wed, Mar 4, 2015 at 1:03 PM, Yahya Muhammad

Re: $$Excel-Macros$$ Re: Help Needed

Try this... Press Alt + F8 Run macro, on prompt enter date for which you are updating data..macro will copy data from daily data sheet to main sheet... Cheers!! On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah todhavals...@gmail.com wrote: ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm

Re: $$Excel-Macros$$ Load ListBox

Hi Goto Name Manager select LIST press edit there after change refers to address .. Cheers!! On Mon, Mar 2, 2015 at 3:01 PM, Mihai Ghilea mihai.ghi...@metabras.ro wrote: Hi experts, I found this EXCEL book on your forum and I want to use it, but I d’ont now where I can change source of

Re: $$Excel-Macros$$ Excel Tip

not change as per you saying. Pls explain me On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi v...@vabs.in wrote: Dear Amar Data in col b date only, you just need to change format of col B to date by selecting col b pressing ctr+shift+3 Cheers!! On Wed, Feb 25, 2015 at 5:11 PM, amar takale

Re: $$Excel-Macros$$ Excel Tip

...@gmail.com wrote: pls look sheet where sheetl1 not change as per you saying. Pls explain me On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi v...@vabs.in wrote: Dear Amar Data in col b date only, you just need to change format of col B to date by selecting col b pressing ctr+shift+3 Cheers

Re: $$Excel-Macros$$ SOLVE THIS

Both is working good .. On Fri, Feb 27, 2015 at 11:55 AM, Mayank Mishra mayank.mishra...@gmail.com wrote: Try =DATE(20RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2)) It will convert the string as date On 2/27/15, Sam Mathai Chacko samde...@gmail.com wrote: =--TEXT(RIGHT(A1,6),00\/00\/00) On 27

Re: $$Excel-Macros$$ Excel Tip

type ctr + ; in excel cell, format which you get is default date format... On Fri, Feb 27, 2015 at 6:33 PM, amar takale amartak...@gmail.com wrote: I have no access to see.Pls see print shot. On Fri, Feb 27, 2015 at 6:26 PM, Vaibhav Joshi v...@vabs.in wrote: what default date format of your

Re: $$Excel-Macros$$ Excel Tip

file for date issue not converted in same format as per your trick,why? i always use text to column operation trick for same format. On Wed, Feb 25, 2015 at 3:46 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers Chandan Gaurav On Tue, Feb 24, 2015 at 11:57 AM, Gaurav Devrani gauravdev1

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

This is superb MV Cheers!! On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth michaelvino...@gmail.com wrote: Hi Sal Sal , Please find the attached updated macro file. Regards, MV On Wednesday, February 25, 2015 at 1:41:10 AM UTC+5:30, Sal Sal wrote: hummm but i dont see any and

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hey sandeep.. Good to see you man.. On Mon, Feb 16, 2015 at 10:38 AM, Sandeep Sharma sandeepsharma4...@gmail.com wrote: ​Hi, Myself Sandeep Sharma from Punjab, i am working in ​Steel manufacturing company as accounts officer. I want to learn VBA macros through this group. Regards With

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

hi Dhamu.. post query in separate post, this thread is for introduction only. Cheers!! On Sun, Feb 22, 2015 at 9:05 PM, dhamu handsome dhamuhands...@gmail.com wrote: hi, i need a macro to take the screenshot of the PDF Doument and paste in the outlook email . can u please help me regarding

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Vidhuraj.. good to see you.. On Mon, Feb 16, 2015 at 1:25 AM, vidhu raj vidhuraj@gmail.com wrote: Hi , How are you ? I am Vidhuraj from Kerala, I am working as an accountant at ITL World Travel Management Company In KSA, Regards, Vidhuraj M. On Friday, June 8, 2012 at

Re: $$Excel-Macros$$ Excel Tip

, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote: Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity

$$Excel-Macros$$ Excel Tip

Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is to transforming data to same format. I will share very good technique to convert all dates to same

Re: $$Excel-Macros$$ Re: Auto clear content

Hi Try this..put this code in worksheet module for which this to be work, this will delete content of column 3, you can set to desired column: *Private Sub Worksheet_SelectionChange(ByVal Target As Range)Columns(3).ClearContents 'clears content of column 3End Sub* *Cheers!!* *O*n Tue, Feb

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

I mean free file.. On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created

Re: $$Excel-Macros$$ VBA on Webpage

This works withe me.. IE.document.getElementsByName(selectedCode).Item(0).Checked = True Cheers!! On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Joshi v...@vabs.in wrote: can you share webpage url where you are performing this? On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja rockerna

Re: $$Excel-Macros$$ VBA on Webpage

can you share webpage url where you are performing this? On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja rockerna...@gmail.com wrote: input type=radio name=radio_fulfillment id=radio_fulfillment class=radio_type Achieved code : - ieRadio.Item(radio_fulfillment)(0).Checked = True

Re: $$Excel-Macros$$ Count duplicate records.

what values do you want in col K, L M? On Fri, Feb 13, 2015 at 6:08 AM, Ahmad Mustfa ahmadmus...@gmail.com wrote: it's excel function. On Wed, Feb 11, 2015 at 12:47 PM, Paul Schreiner schreiner_p...@att.net wrote: REALLY need more infomation. I was tempted to leave it at that:

Re: $$Excel-Macros$$ Want to disable copy, cut paste

You can protect sheet/wb and disable cut/copy /paste.. On Fri, Feb 13, 2015 at 11:50 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: I want to disable copy, cut paste in the attached file. And I also request If Copy, cut paste is disable in this file, it should not disable it

Re: $$Excel-Macros$$ VBA on Webpage

wrote: This works withe me.. IE.document.getElementsByName(selectedCode).Item(0).Checked = True Cheers!! On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Joshi v...@vabs.in wrote: can you share webpage url where you are performing this? On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja rocke

Re: $$Excel-Macros$$ Want to disable copy, cut paste

...@gmail.com wrote: but how ? On Fri, Feb 13, 2015 at 1:41 PM, Vaibhav Joshi v...@vabs.in wrote: You can protect sheet/wb and disable cut/copy /paste.. On Fri, Feb 13, 2015 at 11:50 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: I want to disable copy, cut paste in the attached file

Re: $$Excel-Macros$$ VBA on Webpage

=selectedCode value=OC-DEL-SHAHDARA type=radio id=4 On Friday, February 13, 2015 at 2:12:01 PM UTC+5:30, Vabz wrote: This works withe me.. IE.document.getElementsByName(selectedCode).Item(0).Checked = True Cheers!! On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Joshi v...@vabs.in wrote: can you

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu,

  1   2   3   4   5   6   7   8   9   10   >