Forum

m m
@coral
Active Member
Joined: Apr 18, 2020
Topics: 4 / Replies: 6
Reply
RE: replace blank with macro vba code

hi first of all thank you for your help and could you please change code a bit ( Set r = Selection) selection have to be constant :R2 up to...

5 years ago
Forum
Reply
RE: Merge 2 formulas for specified column in vba code

hi thank you Mr Treacy i appreciate your help some one else helped me in this issue and finally i found it i wanted this below formula ...

5 years ago
Forum
Topic
Forum
Replies: 3
Views: 50
Reply
RE: Merge 2 formulas for specified column in vba code

Hi what i mean is =if(L2-E2=L2;true [BLANK];false[L2-E2]) or =if(l2-e2=l2;"";if(l2-e2<>l2;"l2-e2')) or Range("m2:m" & LR) ...

5 years ago
Forum
Topic
Reply
RE: slope of a line (x coefficient of trend line ) in chart & sheet name

hi again from yesterday7 hours later up to now i have understood that i can find slope with this =SLOPE(INDIRECT("'"&A2&"'!R2:R19"),IND...

5 years ago
Forum