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

alue = "181 days up" ActiveCell.Select 'goes back to A2 ActiveCell.Offset(1, 0).Select ' goes to the next row Loop Application.ScreenUpdating = True End Sub Thank you again! Best regards, DanJ On Thursday, September 11, 2014 8:5

$$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 for

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 tes

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) o

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

>0,"1 to 30 days",IF(A2<=0,"Current")) How do I convert said 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

$$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 ge

$$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).Ro

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

Dear Experts, Thank you for your quick replies. Sorry, if my question was not clear. What I wanted to find is the last row within the range A37:A115 of the first workbook. Again, thank you. DanJ On Friday, August 30, 2013 12:39:15 PM UTC+8, DanJ wrote: > > Dear Experts, > &

$$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 confid

$$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