Re: $$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch error -reg

Dear Shri Pal Schreiner, I really took your "different approach" solution as "deepavali bumber", which make me to know more about "Dictionary Objects" and I will try to learn. This 'opening' gives me a great happiness. A small key always open a big door behind it. My sincere thanks to you.  -R.K

Re: $$Excel-Macros$$ Help Required

Hi neeraj, see the attachment. -- ***Best Regards, Ms Excel User * On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RU

Re: $$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch error -reg

Just because I was bored and wanted to play a bit. I wrote a somewhat different approach to your macro. I utilized "Dictionary Objects" for each of the readings and total values you were collecting. I initialized the Objects, then read through the data and added the values to the Dictionary Object

$$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch error -reg

Dear Expert Paul Schreiner,       "Thank you" for your remarks.  After correcting the"spaces" into "0",it works.   -R.Karunanithi. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accu

Re: $$Excel-Macros$$ $$excel-macro-vba for sumif function-type mismatch error-reg

You COULD add a "On Error Resume Next" if this type of thing could potentially happen again. BTW:  what is it that the code is intended to do? It seems to run fairly slowly. I bet I could speed it up! although.. if it does what you want.. I guess there's no need to fix it.   Paul -

Re: $$Excel-Macros$$ $$excel-macro-vba for sumif function-type mismatch error-reg

The problem is that Cells D263 and D355 have a space in them. When you try to issue  k = k + " ", you get a "Type Mismatch" because you cannot add a space to an integer   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In a

Re: $$Excel-Macros$$ execute macro on delate

Have you played with the VBE debugger? You can step through the macro one line at a time and watch what the different variables are being set to. For the macro: = Private Sub Worksheet_Change(ByVal Target As Range)    

Re: $$Excel-Macros$$ vba to loop through the visible cells.

Doesn't that loop through all cells in all columns AND rows? Even though that's what he ASKED for, that's probably not what he meant. I'd use something like: Sub testvis()     Dim R     For R = 1 To ActiveCell.SpecialCells(xlLastCell).Row     If (Not Cells(R, "A").EntireRow.Hidden) Then  

RE: $$Excel-Macros$$ vba to loop through the visible cells.

For each cell in Range("A1").CurrentRegion.SpecialCells(xlcelltypevisible) 'Your code here next Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of t vinay Sent: 02 November 2012 8:11 To

Re: $$Excel-Macros$$ execute macro on delate

Paul,   thanks a lot is working as I wanted, it will take me some time to figure it up how is working, but its so gd.   Thanks   Pawel From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Friday, November 2, 2012 2:12 PM Subject: Re: $$Excel-Macros

$$Excel-Macros$$ vba to loop through the visible cells.

Hi Team, Can you help with the vba code to loop through the each(visible) cell of the filtered data in a sheet. Thanks for your help! -- Regards, Vinay. T -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for viol

Re: $$Excel-Macros$$ execute macro on delate

I have a couple of solutions for you. (with lessons along the way) First, in the Change Event, Target CAN be more than one cell. For example, if you decide to clear all values in the column, you'd select the range and hit "delete". Then, Target becomes an ARRAY of cells. What I like to do is proc

Re: $$Excel-Macros$$ execute macro on delate

Hi All,   I should attached file with it. about te file - this simple calculator for stock week cover. So input figure in columns "input" and calculate you number of weeks cover. With this file I have 2 problems to resolve:   I've made simple macro to calculate week covers (when you inset value i

$$Excel-Macros$$ Project Manager :: Boston, MA

DIRECT CLIENT - In person interview is needed after TELEPHONIC ROUND. Location: Boston, MA Duration: 9+ months Rate: Open C2C/W-2 (37.5 hrs/week) Skills Needed: . Minimum 3 years of project management experience in a technology environment . Proven track record of delivering large-s

Re: $$Excel-Macros$$ Re: QC results update tool

There really is no way for us to help you with the limited information you've provided. Actually, that's not true. There are LOTS of ways. hundreds of thousands of ways. MOST, except for perhaps a hundred or so, are not relevent to your situation. So, to narrow it down, We would need to know spec

Re: $$Excel-Macros$$ Help Required

Hi, use this =ROUND(C3,2) On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use

RE: $$Excel-Macros$$ execute macro on delate

Private Sub Worksheet_Change(ByVal Target As Range) 'Your code goes here End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: 02 November 2012 5:35 To: excel-macros@googlegro

Re: $$Excel-Macros$$ execute macro on delate

I take it you mean "delete"? Are you wanting to do this for a specific sheet or all sheets in your workbook? You can use a Change "event" macro. for a single sheet, Worksheet_Change() for all sheets: Workbook_SheetChange() in these macros, simply test for the target value = "". If you want a S

Re: $$Excel-Macros$$ Re: Help Required

Hi Cheer, Please use the same mail chain for solution instead of new mail. Aamir Shahzad On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote: > Hello Neeraj > > CTRL+1 on the value column --> Custom --> select type *0.00* > > > cheers > > > On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan

Re: $$Excel-Macros$$ Re: Help Required

Hi Cheer, Please use the same mail chane for solution instead of new mail. Aamir Shahzad On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote: > Hello Neeraj > > CTRL+1 on the value column --> Custom --> select type *0.00* > > > cheers > > > On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauha

Re: $$Excel-Macros$$ Help Required

hi Neeraj, You can just use the Ctrl+Shift+~ key for general format. Aamir Shahzad On Fri, Nov 2, 2012 at 5:21 PM, sunil jagtap wrote: > Hi Neeraj, > > Please try below formula > > =ROUND((C3*100),2) > > Thanks and Regards, > Sunil > > > > On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan > wrote

Re: $$Excel-Macros$$ Help Required

Hi Neeraj, Please try below formula =ROUND((C3*100),2) Thanks and Regards, Sunil On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RU

$$Excel-Macros$$ Re: Help Required

Hello Neeraj CTRL+1 on the value column --> Custom --> select type *0.00* cheers On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan wrote: > > Dear Experts, > > kindly find the attached sheet. > -- Join official facebook page of this forum @ https://www.facebook.com/discussexc

$$Excel-Macros$$ Help Required

Dear Experts, kindly find the attached sheet. -- 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 Help, Formula

$$Excel-Macros$$ execute macro on delate

Hi All,   I need your help on this. I'd like to run macro when I delate value from the cell. So I pushing "delate" and macro run. I couldn't find anything on the web so if you can help me on this.   regards,   Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discus

RE: $$Excel-Macros$$ Vlookup Book

Dear Noorain, Are you back? Could you please share a book to be written on vlookup? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of noorain.ans...@gmail.com Sent:

$$Excel-Macros$$ Re: Pls help

I dont think if there is any direct way you can do this , if dont have any blank cells in your data, 1) Select your data 2) Repalce your value to blanks by Checking "Match Entire Cell Contents" in Find Replace dialoge box , 3). Press CTRL+G ( Go to) 4) Press ALT+S (Special) 5) Press K ( Blanks)

$$Excel-Macros$$ Re: QC results update tool

So , how would you like to automate the process? On Friday, 2 November 2012 01:39:51 UTC+5:30, Nevin wrote: > > HI Rajan/Friends, > > Thanks for your intrest in helping me. > > Objective of the tool is to update all the test case results in QC from an > excel file through macros which inturn

Re: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect

pls share that sheet with us On Fri, Nov 2, 2012 at 2:21 PM, Pravin Gunjal wrote: > *Still waiting for the reply. Thanks. > * > -- Forwarded message -- > From: Pravin Gunjal > Date: Thu, Nov 1, 2012 at 12:12 PM > Subject: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to

Fwd: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect

*Still waiting for the reply. Thanks. * -- Forwarded message -- From: Pravin Gunjal Date: Thu, Nov 1, 2012 at 12:12 PM Subject: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect To: excel-macros@googlegroups.com *Hello,* *Can somebody help me out on this issue