Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Rows("12:18").Hidden = Worksheetfunction.countif(Range("A1:G2"),"ABC") > 0 End Sub On Apr 2, 2016 19:18, "NIJ" wrote: > > > On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote: >> >> I want to aply

Re: $$Excel-Macros$$ SAME MACRO FOR MANY CELLS

d email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:

Re: $$Excel-Macros$$ help required

nsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https

Re: $$Excel-Macros$$ Changing Embedded Chart Axis Label Font Fails

acros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NO

Re: $$Excel-Macros$$ SOLVE THIS

=--TEXT(RIGHT(A1,6),00\/00\/00) On 27 Feb 2015 11:47, sush.dav...@gmail.com wrote: I have a data like below where I need only date. S270215 R270215 -- 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$$ Array_concept

. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

Re: $$Excel-Macros$$ getting a macro to work on conditional formatting

Dan, you can get it yo work in Excel 2010 or above. There is a property they introduced which will help to identity the actual interior color or the color rendered by conditional format. Regards Sam On 7 Aug 2014 06:57, Daniel Parmet danielpar...@gmail.com wrote: I have a macro (first I've ever

Re: $$Excel-Macros$$ Sequence Formula

, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Sam Mathai Chacko -- 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$$ Excel 2013 Userform Popup menu

...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Run time error - Type mismatch

SrcCmod As VBIDE.CodeModule Dim DstCmod As VBIDE.CodeModule Thanks, Sam Mathai Chacko On Mon, Apr 28, 2014 at 1:30 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check reference is given to Microsoft Visual Basic for Applications Extensibility 5.x Thanks On Mon, Apr 28, 2014 at 5:50 AM, Sam

Re: $$Excel-Macros$$ Run time error - Type mismatch

Ondrej, for that you'll have to enable programmatic access to VBA. Just search the internet how to do that, or post back. Someone will help you. Regards, Sam Mathai Chacko On Apr 27, 2014 7:49 PM, Ondrej o.pel...@gmail.com wrote: HI buddies there is an error in the last sequence of this code

Re: $$Excel-Macros$$ Re: Bypass the VBA Project Password

Read Rule No. 3 Regards, Sam Mathai Chacko On Wed, Feb 12, 2014 at 1:00 AM, Bernardo Pereira berd...@gmail.com wrote: Here's the file I need to crack!! Please help me!! Tks -- 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

Re: $$Excel-Macros$$ Date Format conversion

...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Reverse a series of number in excel

)) Regards, Sam Mathai Chacko On Sun, Dec 1, 2013 at 8:56 PM, Nishant Sharma sharma.nishan...@gmail.comwrote: 1 4 2 3 3 2 4 1 On Sun, Dec 1, 2013 at 8:34 PM, ashish koul koul.ash...@gmail.com wrote: can u share sample file ? On Sun, Dec 1, 2013 at 7:54 PM, Nishant Sharma

Re: $$Excel-Macros$$ Date Substraction

Srini, are you looking to subtract dates in column C from column B or vice versa, ie, B-C or C-B? In addition, some values are coming as #N/A. What to do with those? Regards, Sam Mathai Chacko On Sun, Dec 1, 2013 at 3:57 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear all I want

Re: $$Excel-Macros$$ Address of Shapes

The property TopLeftCell in itself is of type range. The code above can be shorter. Sub test() Dim shp As Shape For Each shp In ActiveSheet.Shapes MsgBox shp.TopLeftCell.Address Next End Sub Regards, Sam Mathai Chacko On Tue, Nov 19, 2013 at 2:22 PM, Chandra Shekar chandrashekarb

Re: $$Excel-Macros$$ Web Query Issues

. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ excel question

Are you looking for this? =COUNTIF($D$2:$D$15,S) Regards, Sam Mathai Chacko On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes rbar...@hcsgcorp.com wrote: First of all thank you. I am, at best, a novice user of excel. Even though we use it for its most basic functions daily. I am attempting

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

Function INDIRECTVBA(strSource As String) INDIRECTVBA = Evaluate(= strSource) End Function Regards, Sam Mathai Chacko On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, i need an assistance with an alternative way of getting the indirect

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

PFA On Thu, Oct 31, 2013 at 11:50 PM, Hilary Lomotey resp...@gmail.com wrote: thanks Sam, can you send it in excel format, i typed indirectvba=then i refered to the datavalidation, but am getting an error. kind;y send me the file. thanks On Thu, Oct 31, 2013 at 6:15 PM, Sam Mathai Chacko

Re: $$Excel-Macros$$ information

this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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$$ Date formatting prob! help!

Hi mum, The 5 digit number is the equivalent value of the corresponding date in that cell. You should see the correct format if you press CTRL+` ` is normally found just about the TAB key Regards, Sam Mathai Chacko On Fri, Sep 20, 2013 at 8:31 PM, Dawn dawn1909simp...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ Can I add a bespoke menu in Excel 2013?

Hi Dave, Since many of us have switched to Excel 2007 or above, it would be nice if you can attach a picture of this bespoke menu, and then try to relate to what you are expecting in your new version of Excel. Regards, Sam Mathai Chacko On Thu, Sep 19, 2013 at 8:38 PM, Dave Tomlinson dave.t

Re: $$Excel-Macros$$ Activate Particular Window

Interesting. I've worked through 8 to 14, never got a chance to work on 15. Did you try changing the modal property of the userform? Or a line in the end saying UserForm.activate? Sam Mathai Chacko On Sep 7, 2013 8:01 AM, John Wilson wilson9...@gmail.com wrote: I'm in the process of upgrading

Re: $$Excel-Macros$$ Loop to check if cell is blank, if so copy the cell above

this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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$$ Loop to check if cell is blank, if so copy the cell above

, not just use it :) Thanks Sam, Clark On Sunday, September 1, 2013 3:03:53 PM UTC-5, Sam Mathai Chacko wrote: Try this Clark With Range(A1:A Cells(Rows.Count, A).End(xlUp).Row).** SpecialCells(xlCellTypeBlanks) .FormulaR1C1 = =R[-1]C .Value2 = .Value2 End

Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm On Aug 21, 2013 11:04 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Mog-Godiva, You can find the digitizer from the following links, http://digitizer.sourceforge.net/

$$Excel-Macros$$ Re: saving unique values from a dependant combobox to a sheet

Cross-posted at http://www.excelfox.com/forum/f2/extract-unique-values-based-on-dependant-combobox-selections-1353/ Please read http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/ Regards, Sam On Saturday, 10 August 2013 02:18:19 UTC+5:30, Ricardo Fourie wrote: good day i have

Re: $$Excel-Macros$$ Re: Convert number of days to month and day (ie, 035 = 2/4)

My understanding was that Don was actually looking for a result that is in M/Y format, not date format. So the solution should be =TEXT(DATE(2013,1,*No. Of Days*), m\/d) where *No. Of Days* is the range where the numbers are listed, for example A2. Regards, Sam Mathai Chacko On Thu, Aug 8, 2013

Re: $$Excel-Macros$$ Macro to delete row with specific phrase

://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ Convert number of days to month and day (ie, 035 = 2/4)

Don, try passing the number of days to the date function like this. =TEXT(DATE(2013,1,No. Of Days - 1), m\/d) Sam MATHAI CHACKO On Aug 8, 2013 4:11 AM, Don Barton donaldb...@gmail.com wrote: Greetings, I work at a hospital laboratory and we have an expiration date barcode on blood

Re: $$Excel-Macros$$ Convert number of days to month and day (ie, 035 = 2/4)

In fact you probably don't need that - 1. Remove it. I'm just typing this on my handset, so please don't mind. On Aug 8, 2013 6:50 AM, Sam Mathai Chacko samde...@gmail.com wrote: Don, try passing the number of days to the date function like this. =TEXT(DATE(2013,1,No. Of Days - 1), m\/d) Sam

Re: $$Excel-Macros$$ excel macro help on regular basis required- on weekly payment/hourly basis

an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- Are you

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ Is it possible to hide the name manager menu?

-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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$$ Collate data from folder

-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Range(A1).CurrentRegion.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(4, 5, 6) Sam Mathai Chacko On Sat, Jun 22, 2013 at 1:08 PM, priti verma pritiverma1...@gmail.comwrote: Hi group, pleaase help me to solve this .see attachment for more clarification. I want a macro

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

, do you Know any good site from where i Learn array in vba. On Sat, Jun 22, 2013 at 1:22 PM, priti verma pritiverma1...@gmail.comwrote: Thanks sam its working fine, On Sat, Jun 22, 2013 at 1:14 PM, Sam Mathai Chacko samde...@gmail.comwrote: Range(A1).CurrentRegion.Subtotal GroupBy:=3

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

Cells(Rows.Count, E).End(xlUp).Offset(1, 0).Row) cancel = True With Selection Selection.Copy Destination:=rng End With End Sub Regards, Sam Mathai Chacko On Sun, Jun 16, 2013 at 4:09 PM, VBA VABZ v...@vabs.in wrote: Hi Try this code: Private Sub Worksheet_BeforeRightClick(ByVal Target

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

you get in to cell edit mode. So sheet change event stops, if you want to copy data to destination more than once you can achieve it with right click. Cheerz. On 16 Jun 2013 17:28, Sam Mathai Chacko samde...@gmail.com wrote: It wasn't Single click that Sajid asked for. It was double click

Re: $$Excel-Macros$$ how to remove special character from work sheet

/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ copy formula down

to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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$$ Re: VBA to Open Access When User Has Runtime Access Installed

at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ Round off in multiple of 25 paise!

And this one too =MROUND(A1-0.25/2,0.25) Regards, Sam Mathai Chacko On Wed, Apr 17, 2013 at 10:28 PM, Kanwaljit Singh kanwal...@gmail.comwrote: Much Better Paul :) On Wed, Apr 17, 2013 at 10:24 PM, Paul Schreiner schreiner_p...@att.netwrote: since you're rounding to .25, then you can

Re: $$Excel-Macros$$ Required Roundup Formula.............

Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5) should be fine Regards, Sam Mathai Chacko On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma pritiverma1...@gmail.comwrote: Hi Kuldeep I think this formula fullfil your requirement. =ROUNDUP((A2*2)/10,0)*10/2

Re: $$Excel-Macros$$ VBA to Open Access When User Has Runtime Access Installed

/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ vlookup madness

If you want to look for exact matches, you must use =VLOOKUP(Lookup_Value, ArrayRangeToLookAt, Column_Index, Whether Approximate Match Or Not) So try =VLOOKUP(A1,$E$1:$F$17,2,FALSE) Regards Sam Mathai Chacko On Wed, Apr 10, 2013 at 5:51 AM, alanthomas...@gmail.com wrote: I am really confused

Re: $$Excel-Macros$$ Is there a way to exclude PERSONAL.xls workbook from list of active workbooks in macro?

If your static workbook is opened from the code, then you probably are keeping the 'dynamic' workbook open first. So it would be best to replace your underlined code above with *Set wb = ActiveWorkbook* Regards, Sam Mathai Chacko On Sun, Apr 7, 2013 at 7:28 AM, LJGIT lgem...@earthlink.net wrote

Re: $$Excel-Macros$$ Previous sheet name using formula

by formula. Any how i found solution completed my project by other way. Thanks N.Sundarvelan 9600160150 On Wed, Mar 27, 2013 at 9:49 PM, Sam Mathai Chacko samde...@gmail.comwrote: You could also use the MID function instead of REPLACE example =MID(CELL(filename),FIND(],CELL(filename

Re: $$Excel-Macros$$ Previous sheet name using formula

completed my project by other way. Thanks N.Sundarvelan 9600160150 On Wed, Mar 27, 2013 at 9:49 PM, Sam Mathai Chacko samde...@gmail.comwrote: You could also use the MID function instead of REPLACE example =MID(CELL(filename),FIND(],CELL(filename))+1,31) Note that the second formula

Re: $$Excel-Macros$$ Previous sheet name using formula

the formula =INDEX(SheetNames,MATCH(SheetName,SheetNames,0)-1) Regards, Sam Mathai Chacko On Wed, Mar 27, 2013 at 7:01 PM, Paul Schreiner schreiner_p...@att.netwrote: How do you define Previous Sheet Name? Do you mean the name of the sheet before it was changed to the current name? or do you mean

Re: $$Excel-Macros$$ Previous sheet name using formula

it using formula was to avoid having to do anything to do with macro in the first place) Regards, Sam On Wed, Mar 27, 2013 at 9:44 PM, Sam Mathai Chacko samde...@gmail.comwrote: I would agree with Paul. The best thing to do is to write a function like this Function PREVSHEETNAME() As String

Re: $$Excel-Macros$$ Help with Deciphering an Excel Formula

Here's an explanation to a similar but not exactly same formula. I'm sure you can decipher your equation once you go through the link below. http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/ Regards, Sam Mathai Chacko On Wed, Mar 20, 2013 at 8:15 PM, Chris christoph

Re: $$Excel-Macros$$ Mass Emails sending excel macros file

this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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$$ Support -

. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ CLEAR CONTENTS of cells with value 0

Why don't you use the option 'Show zero in cells that have zero value', in the advanced tab of Excel options (Excel 2007) Sam Mathai Chacko On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar khadilka...@gmail.comwrote: Dear Sir, I have ANY excel sheet ,some cells have value ZERO [ numeric

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

Then WLOOKUP = rng.Cells(lngI) Exit Function End If Next lng End Function Regards, Sam Mathai Chacko On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K mks@gmail.comwrote: Hi Friends, Need a help to create macro in a Data tab where it can recongnize a word

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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

Re: $$Excel-Macros$$ excel Application with a userdefined ribbon built in using xml Error

Divaker, can you post this file? Regards, Sam Mathai Chacko On Wed, Nov 14, 2012 at 2:57 PM, Divaker Pandey divake...@gmail.com wrote: Hello Exprets, I am struggling with the following strange problem in MS Excel 2007 (rarely occurs). I have an excel Application with a userdefined ribbon

Re: $$Excel-Macros$$ How to delete alternate sheets faster

+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ excel macros for pasting to selected range

Is this what you wanted?? Sub CopyToRows() Dim strRange As String strRange = Selection.EntireRow.Address(0, 0) Range(strRange).Value = Range(2:2).Value End Sub Regards, Sam Mathai Chacko On Thu, Nov 1, 2012 at 12:50 AM, key log target...@gmail.com wrote: Hi all

Re: $$Excel-Macros$$ Google Map and Excel Integration Using VBA

@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ For Indian Accountants Taxation professional. Check ISPANVALID

. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko

Re: $$Excel-Macros$$ For Indian Accountants Taxation professional. Check ISPANVALID

http://www.excelfox.com/forum/f13/validating-pan-indian-format-409/ On Wed, Oct 17, 2012 at 8:39 PM, Sam Mathai Chacko samde...@gmail.comwrote: Similar Thread here too On Wed, Oct 17, 2012 at 7:24 PM, Vabz v...@vabs.in wrote: Hi I have created a function to find our invali PAN

Re: $$Excel-Macros$$ Is it possible to Open a Particular Website and Login to it using VBA???

This is a link by Lalit Mohan, one of the members of this forum http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ Regards, Sam Mathai Chacko On Mon, Oct 8, 2012 at 11:05 PM, sreekanth m sreekanthm.namb...@gmail.comwrote: Hello Friends, Can anyone help

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

http://www.excelfox.com/forum/f2/conditional-format-based-percentage-variance-585/ Regards, Sam Mathai Chacko On Sat, Sep 29, 2012 at 7:35 PM, vinod rao vinod.ma...@gmail.com wrote: Hi, I want to know how to do a conditional formatting on numbers based on the calculated percentage % Please

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

=(I3-J3)/J30 (RED) =AND((I3-J3)/J3=0,(I3-J3)/J3=2%) (YELLOW) =(I3-J3)/J35% (GREEN) Find attachment also Regards, Sam Mathai CHacko On Sat, Sep 29, 2012 at 8:39 PM, vinod rao vinod.ma...@gmail.com wrote: Any suggestions? I need conditional formating Yellow when the delta is 0% +2% Thanks

Re: $$Excel-Macros$$ circular x axis in excel graph

, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

http://www.excelfox.com/forum/f5/ Sam Mathai Chacko On Mon, Sep 24, 2012 at 10:30 PM, V S Rawat g vsra...@gmail.com wrote: Sorry for OFF TOPIC post. Please suggest to me a similar active group for MS WORD Macros issues that I have to ask? Thanks. -- Rawat -- Join official facebook

Re: $$Excel-Macros$$ OFF TOPIC: Please suggest a similar active group for MS WORD Macros?

Yeah, when you go to a particular forum in the site, like Word Help, on the top of the table, you'll find Forum Tools Subscribe to this Forum Regards, Sam Mathai Chacko On Tue, Sep 25, 2012 at 1:09 AM, V S Rawat g vsra...@gmail.com wrote: On 9/24/2012 11:09 PM India Time, _Sam Mathai Chacko_

Re: $$Excel-Macros$$ Re: Excel Formula challenge

, |) End With End Function Regards, Sam Mathai Chacko On Sun, Sep 16, 2012 at 7:40 PM, dguillett1 dguille...@gmail.com wrote: Put this function in a REGULAR module. Then =myfunc(a1) Function myfunc(xx) Dim nodupes As New Collection arr = Split(xx, |) For i = LBound(arr) To UBound

Re: $$Excel-Macros$$ Plant Operating Days in Each Year

D10=MAX(0,MIN(D$8,$C2)-MAX($B2,D$7)+1) And drag down and across Regards, Sam Mathai Chacko On Sun, Sep 16, 2012 at 9:07 PM, sharad jain jainshar...@gmail.com wrote: Dear Experts, Please help me in calculating operating days in the attached sheet. There are 2 contracts which will run after

Re: $$Excel-Macros$$ Count multiple criteria in a column with the help of VBA

Rows.Count).End(xlUp).Row) For i = 2 To Sheet2.Range(A Rows.Count).End(xlUp).Row Sheet2.Cells(i, 2).Value = Evaluate(=SUMPRODUCT(( rng.Address(, , , True) =A i )*(( rng1.Address(, , , True) =12)+( rng1.Address(, , , True) =13 Next End Sub Regards, Sam Mathai CHacko On Thu, Sep 13, 2012

Re: $$Excel-Macros$$ Creating Custom Ribbon

The threads in this link talk a lot about Ribbon development in very simple steps http://www.excelfox.com/forum/f10/ Regards, Sam Mathai Chacko On Tue, Sep 11, 2012 at 10:50 PM, koul.ash...@gmail.com wrote: ** Visit www.rondebruin.nl/ribbon.htm Sent on my BlackBerry® from Vodafone

Re: $$Excel-Macros$$ entering Array formula in lookup function

Dave, I guess Paul's issue is more on not being able to enter this as an array formula. Changing the vector array elements to strings probably doesn't really make a difference if the issue is about entering the CSE formula. Regards, Sam Mathai Chacko On Sat, Sep 8, 2012 at 1:38 AM, David Grugeon

Re: $$Excel-Macros$$ Re: treeview

+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ entering Array formula in lookup function

in manually. David On 8 September 2012 17:44, Sam Mathai Chacko samde...@gmail.com wrote: Dave, I guess Paul's issue is more on not being able to enter this as an array formula. Changing the vector array elements to strings probably doesn't really make a difference if the issue is about

Re: $$Excel-Macros$$ show only last four digit of the number

Would this help? Regards, Sam Mathai Chacko On Fri, Sep 7, 2012 at 8:45 PM, maksood alam 786maks...@gmail.com wrote: Partially correct, but it show as per below *Numbers* *Required out put* 555-55-5505 ***-***-5505 555-55-125-0 ***-**-***-* 555-55--23 ***-**-**55

Re: $$Excel-Macros$$ treeview

Regards, Sam Mathai Chacko On Fri, Sep 7, 2012 at 10:08 PM, james D jpadlimi...@gmail.com wrote: Hi. I am a VBA developer (Excel mainly) - I have built an Excel dashboard which contains a userform with a treeview on it. It all works fine pre Windows 7 with Office 2010, but with Windows 7

Re: $$Excel-Macros$$ entering Array formula in lookup function

Shouldn't they be strings? =LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#}) Regards, Sam Mathai Chacko On Fri, Sep 7, 2012 at 10:37 PM, Paul Schreiner schreiner_p...@att.netwrote: Odd... I seem to be suffering a temporary loss of cognitive function. (can't think straight) I'm trying

Re: $$Excel-Macros$$ show only last four digit of the number

Didn't you find my solution worthwhile? Sam Mathai Chacko On Fri, Sep 7, 2012 at 10:52 PM, maksood alam 786maks...@gmail.com wrote: Paul, I want excel function solution. On Fri, Sep 7, 2012 at 10:21 PM, Vabs in.vaib...@gmail.com wrote: superb answer sam.. Thx On Friday, September 7

Re: $$Excel-Macros$$ show only last four digit of the number

If IsNumeric(Mid(strText, lngLen, 1)) Then lng = lng + 1 If lngLeaveDigits lng Then Mid(strText, lngLen, 1) = * End If End If Next ASTERIK = strText End Function Regards, Sam Mathai Chacko On Fri, Sep 7, 2012 at 10:57 PM, maksood alam

Re: $$Excel-Macros$$ entering Array formula in lookup function

*- -- *From:* Sam Mathai Chacko samde...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, September 7, 2012 1:26:28 PM *Subject:* Re: $$Excel-Macros$$ entering Array formula in lookup function Shouldn't they be strings? =LOOKUP(A2

Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory

Try taking all the values of the used range to a variant variable. Example Sub T() Dim var As Variant var = Worksheets(Name).UsedRange.Value End Sub Regards, Sam Mathai Chacko On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi ruchirjo...@gmail.com wrote: Hello everyone, I am designing a tool

Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory

No it won't. Try using var = Worksheets(Name).UsedRange.Formula Regards, Sam Mathai Chacko On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88 ruchirjo...@gmail.com wrote: Hi sam, Thanks for the reply, but this would not give me information about other cell parameters like dependents. Ruchir

Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member August 2012

to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED

Re: $$Excel-Macros$$ EXCELLENT MIND READING

are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum

Re: $$Excel-Macros$$ MOST REPEATED NO

number, you can use a simpler formula =MODE(--SUBSTITUTE(ROUND(B3:B21,2),MODE(ROUND(B3:B21,2)),MAX(B3:B21)+ROW(INDIRECT(1:ROWS(B3:B21) Regards, Sam Mathai Chacko On Fri, Aug 17, 2012 at 7:07 PM, dguillett1 dguille...@gmail.com wrote: Looks like homework to me also but this should do

Re: $$Excel-Macros$$ Excel VBA Challenge

Sheets(var).Delete .DisplayAlerts = 1 End With End Sub Regards, Sam Mathai Chacko On Tue, Aug 14, 2012 at 8:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Guys, Challenge is to Delete all Sheets Except one without any loop and mapping table. Keep Excelling

Re: $$Excel-Macros$$ What is the future of VBA?

. If VBA isn't there, something will be there that will be similar. And as software evolves, people evolve. So, I for one, don't tend to be apprehensive about changes, or rather, potential changes, such as those. Regards, Sam Mathai Chacko On Sun, Aug 12, 2012 at 2:01 AM, yogananda muthaiah

Re: $$Excel-Macros$$ Activate the word wrap option in excel......

. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Help with Formula Destination

=HYPERLINK(#CELL(address,Sheet3!A1),Sheet3!A1) Regards Sam Mathai Chacko On Mon, Aug 6, 2012 at 9:41 PM, ashish koul koul.ash...@gmail.com wrote: =HYPERLINK(#'SUBSTITUTE(CELL(address,Sheet2!A3),!,'!),Sheet2!A3) On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan ashlyprad...@gmail.comwrote

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

a blank email to excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- 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 Advice

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

Rajan isn't asking about Formula Auditing, which I am sure he is aware of. His question is about the difference between Trace Precedents and Trace Error which are two separate features in Excel. Please read my post before. Regards, Sam Mathai Chacko On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

!!! Chilexcel 2012/8/3 Sam Mathai Chacko samde...@gmail.com Rajan isn't asking about Formula Auditing, which I am sure he is aware of. His question is about the difference between Trace Precedents and Trace Error which are two separate features in Excel. Please read my post before

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

or anything He wanted an answer this reviewer Rajan.. is what matters !!! Chilexcel 2012/8/3 Sam Mathai Chacko samde...@gmail.com 1. Your post came on top of my post, so there is no way of me proposing 'another' solution. 2. It is not your answer ( http://www.dummies.com/how

  1   2   3   4   5   6   >