Search results

I need help to write a code in excel VBA to have my spreadsheet generate a Transaction number down column A. The transaction number should start with 1 and each row below should be 1+ the previous row’s number. Thanks.

Happy holiday to all. I need help to have my excel vba copy a number and then paste it as a negative number in another cell. Can someone please let me know the code to do this? Thanks so much.

Hi everyone, hope all is well. I need some help once again so I'm reaching out to my favorite site that always come true for me. I need to write this formula in VBA but for some reason, I just cannot get it. Can someone help, pretty Please...

I have a simple file that will potentially get a lot less simple. For now, my file has two worksheets, namely: 1. Form 2. Schedule I need to write a macro that will take the info from the Schedule and populate the necessary fields in the Form once in input the CODE field in the Form. I...

If Val(sh1.Cells(i, 22)) > 0 Then The above statement in my loop works great but if I insert/delete columns, I cannot use the fixed number of 22. The number will change depends on how many columns inserted/deleted. How can I use fix this. Please help! Thanks.

Int period start_date = 5/1/2001 end_date = 7/31/2012 Between the start_date and end_date, there are multiple interest rates. Sheet2 shows all interest rates and their interval. I need help in writing a macro that will calculate interest for the entire period (5/1/2001-7/31/2012)...