Re: $$Excel-Macros$$ If Condition Problem

Hi Also you may be required to set myAddIn.Installed = True when condition is met,, because once addin is disabled it wont get automatically enabled/installed. CHeers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 23, 2014 at 10:06 AM, my excel wrote:

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

Ok, chk this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 9:38 PM, Eugene Bernard wrote: > Dear Joshi, > > Thanks for your reply. > > As already explained in my first post, rows having code with 11 is not > to be treated as c

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

Thank you very much Mr.Paul. I have tried it. Succesfull. Can I ask again? Divided by small number square 0.2, how can i get the value, because the VBA assume it zero. Actually i don't want to assume it zero value. On Fri, Sep 19, 2014 at 9:31 AM, Paul Schreiner wrote: > What is the actual

Re: $$Excel-Macros$$ If Condition Problem

thanks a lot sir On Mon, Sep 22, 2014 at 3:41 AM, Vaibhav Joshi wrote: > Hi > > Use this code: > > Sub CompName() > > Dim ThisComputerName As String > Dim myAddIn As AddIn > > If UCase(Environ("computername")) = "PCEARTH" Then > ActiveSheet.Range("S1").Value = "INDIA" >

Re: $$Excel-Macros$$ How to fix a vba code that returns a cell reference

Thank you for trying to explain a solution. The concept is very straight forward I just wanted the value input in next available row between 6-199 and a formula refrencing that cell in the matching column between 202-231. I have a freelancer working on this project now so all is good. On Monday

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not to be treated as completed, since 3 rows having codes as 11 is with status tag blank. The logic for moving the rows from sheet1 to sheet2 is rows with status tag with "C" if it has un

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not to be treated as completed, since 3 rows having codes as 11 is with status tag blank. The logic for moving the rows from sheet1 to sheet2 is rows with status tag with "C" if it has un

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Pramod, Thanks for your prompt reply. Works great! The second macro should run when the Cell Pointer is in Column T on a Highlighted Cell (in red). *Can red be given the RGB value mentioned on my sample data?* I want to copy and transpose cells from the Row where the Max value is found in Co

Re: $$Excel-Macros$$ Track the system Lock

If you want this if you fear that screen lock may interrupt your running macro, then you can use application.screenupdating=false in the beginning of your code. Cheers On Sep 19, 2014 5:49 PM, "Vaibhav Joshi" wrote: > PFA for locking screen.. > > Cheers!! > > > + > *I did not do this for you

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Dear, Please find the Attached file ... Regards P On Mon, Sep 22, 2014 at 2:53 PM, prkhan56 wrote: > Dear All, > > I am using Excel 2010 and have attached a file with my problem. > > I need Two Macros for my problem. > > > > There are two Files (both in a shared location - Path S:\...\...\

Re: $$Excel-Macros$$ FILTER ISSUE

Cheers Bro.. Keep Smiling :) + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 3:39 PM, big smile wrote: > Thank you Vaibhav Bhai for your good command over Excel Formulas > > & God Bless you .. > > You are help is very good to this group. > > K

Re: $$Excel-Macros$$ How to fix a vba code that returns a cell reference

It's VERY confusing trying to follow what you're doing... it seems like you're using chr() functions to convert characters to STRINGS? which doesn't make ANY sense. I'd like to first address your solution, then ask what it is you're trying to do? (lol) For your code: ActiveSheet.Cells(i, 2).Val

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

Hi FA, Click blue button to Run Macro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard wrote: > > -- Forwarded message -- > From: Eugene Bernard > Date: Sun, Sep 21, 2014 at 8:54 PM > Subjec

Re: $$Excel-Macros$$ If Condition Problem

Hi Use this code: Sub CompName() Dim ThisComputerName As String Dim myAddIn As AddIn If UCase(Environ("computername")) = "PCEARTH" Then ActiveSheet.Range("S1").Value = "INDIA" Else MsgBox ("Sorry You are Not a Authorised User") ' below sub programs must b

Re: $$Excel-Macros$$ FILTER ISSUE

Thank you Vaibhav Bhai for your good command over Excel Formulas & God Bless you .. You are help is very good to this group. Keep it up. On Mon, Sep 22, 2014 at 2:44 PM, Vaibhav Joshi wrote: > Chandresh bhai, it is not issue but requirement..here you go... > > Add formula =row() in column P e

$$Excel-Macros$$ If Condition Problem

Sir, i created an add-in for my excel work but i am trying to write a condition it will only run in Computer Name= PCEARTH otherwise sub programs will be disabled automatically or not working thanks Sub CompName() Dim tSName As String Dim ThisComputerName As String ThisComputerNa

Re: $$Excel-Macros$$ FILTER ISSUE

Chandresh bhai, it is not issue but requirement..here you go... Add formula =row() in column P each cell corresponding to data. Add formula =INDIRECT("R"&SUBTOTAL(6,$P$2:$P$9)&"C6",FALSE) to cell B2. So as & when you filter data you will get your desired result. Note: This will work only for fi

$$Excel-Macros$$ FILTER ISSUE

Respected Excel Guru / Friends I have 6 entries in excel files from Raw 3 to Raw 8 I want the formula that --- When ever i filter any raw by selecting any family name - Ex I filter Dhimant Parmar - EX R7 then i want in B1 What ever is in f - column after filter. When ever i change my filter and