carry

For example, if I have Dat= Range("O59:CL59") what have I got ? I cannot see it in a Watch, nor print Len(Dat). What can I do with it ? Can I put it onto another sheet? And could it carry across any attributes (font, back color etc) as well as values ?

I'm trying to carry over numbers after the decimal point (column in green) and add them to the row belowAt the moment, the RED items are being calculated in each row, and the total is show in BLUE. The number in BLUE is then divided by 7.5 and show in GREEN. A. 47.50 47.50 47.00 47.00 189.00...

Dear all, I am trying to compute carry or performance fee for a hypothetical fund. The performance fee or carry is 20% of total profit, provided 1) Hurdle rate or threshold is met 2) High water mark (HWM) clause, i.e. no performance fee is paid unless the net asset value (NAV) for this...

Hello, I've been working with a series of Macros for a little while now. I've been setting up little buttons on a page so they are accessible to a user. It occurred to me how much easier it would be to just create a macro and add it to a ribbon. And it's pretty amazing to have. There is one...

I think I am overlooking something incredibly simple. Whether this is just reformatting the data in a specific pivot table or adding in a logic step with a formula on the rows, but I can't currently figure out how to do it. Here is the issue. I have a data set with quite a few lines. There are...

Hi could any one tell me what is wrong with the below: =IFERROR(IF(AND(U5="",U5<>"A"),(VLOOKUP(T5,Belt,2,FALSE)-VLOOKUP(D5,Belt,2,FALSE)),(VLOOKUP(U5,Belt,2,FALSE)-VLOOKUP(D5,Belt,2,FALSE))),"Absent") I want it to look at Cell U5 to see if it is blank or contains the letter A and if so carry...

Hi Guys, Hope you all had a great New Years! First day back in work and I'm already at a stumbling block... Can anyone please offer advice on why this IF statement is trying to carry out the code after Else even though the initial part of the IF statement is TRUE? Private Sub...

Hey everyone, I trying to figure out a formula for vba, where it checks to see if the the second row is blank. basically if row 2 is blank, do nothing else, carry out program. Writing a monthly report, so some months there's no data in the table, and just want to make sure it doesnt carry...