$$Excel-Macros$$ Re: Convert IF formula to VBA

Thank you Bill for the code. Will try it. Thank you, Paul for your advice. Appreciate it. Regards, DanJ On Wednesday, September 10, 2014 2:35:59 PM UTC+8, DanJ wrote: Dear Everyone, I want to categorize age of receivables based on the number of days due using the formula below

Re: $$Excel-Macros$$ Convert IF formula to VBA

row Loop Application.ScreenUpdating = True End Sub Thank you again! Best regards, DanJ On Thursday, September 11, 2014 8:52:35 PM UTC+8, Paul Schreiner wrote: No problem, once you've asked and answered a couple hundred questions you'll get an idea of what part

$$Excel-Macros$$ Convert IF formula to VBA

formula to VBA and populate the same to the next succeeding rows. Thank you in advance for your help. DanJ -- 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

Re: $$Excel-Macros$$ Convert IF formula to VBA

Hi Paul, Sorry, if my question is vague. I would like VBA to perform the test and enter the result. Thanks. DanJ On Wednesday, September 10, 2014 7:24:49 PM UTC+8, Paul Schreiner wrote: Are you saying that: 1) you'd like to use VBA to insert the =IF() statement? 2) or that you'd like VBA

Re: $$Excel-Macros$$ Convert IF formula to VBA

Hi, I would like VBA to perform the test and enter the result. DanJ On Wednesday, September 10, 2014 7:24:49 PM UTC+8, Paul Schreiner wrote: Are you saying that: 1) you'd like to use VBA to insert the =IF() statement? 2) or that you'd like VBA to perform the test and enter the result? 3

$$Excel-Macros$$ Re: Shorter way of getting sum of each column using VBA

Hi Pramod and Jef, Thank you for your quick reply. I prefer Jef's solution though. By the way Jef, what does number 3 mean after 65536. Thanks again. DanJ On Thursday, August 7, 2014 11:20:24 AM UTC+8, DanJ wrote: Hello everyone, I am trying to get the total of each column K, O, P, T, U

$$Excel-Macros$$ Shorter way of getting sum of each column using VBA

Hello everyone, I am trying to get the total of each column K, O, P, T, U, and V using the codes below. EndRowK = Sheets(1).range(K65536).End(xlUp).Row Sheets(1).range(K EndRowK + 1).Formula = =SUM(K2:K EndRowK ) EndRowO = Sheets(1).range(O65536).End(xlUp).Row

$$Excel-Macros$$ Copy data to next empty row

changes too. How do i determine or code the next empty row where the data from the* third workbook* have to be copied and pasted? Thank you in advance for your help. DanJ -- 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

$$Excel-Macros$$ Re: Need some VBA Question for interview.

Hi Indrajit, Please see attached file. On Thursday, June 28, 2012 7:08:06 AM UTC+8, Bullet wrote: Hi All, Can someone provide me some VBA Question for interview. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential

$$Excel-Macros$$ HOW TO REPLY TO A POST

Sirs, Don Guillet did reply to my query re HELP: SHORTEN MY MACRO USING LOOP. I want to thank him but i don't know how to reply. How i should i reply to him or the group? Thank you. -- -- Some important links for

$$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

Dear Sirs, I have a macro which updates my monthly trial balance. But it's too long. Takes time to process. I want to shorten it particularly step 1, step 3 step 4, using loop which i am not very good at. Please help how to shorten my codes. Below is my macro. Thank you. DanJ STEP 1 Sub