Niallneedshelp
New member
- Joined
- Feb 26, 2021
- Messages
- 1
Hi
i am programming a drawing in excel vba to help me with my work but
im having trouble scaling sizes down to fit on screen and back up again to get real measurements
this is a simplified example of what im doing but the programme is completely dynamic so the percentage and the divisor can be different
I have a starting size e.g. 424 which i need to shrink by 40% = 254.4. i then need to dived it by e.g 2 =127.2 .now i need to scale this back up so it accurately represents the divided value of 424/2. if i increase 127.2 by 40% i get 177.8 when correct answer is 212.
i know the answer is probably simple
thanks
i am programming a drawing in excel vba to help me with my work but
im having trouble scaling sizes down to fit on screen and back up again to get real measurements
this is a simplified example of what im doing but the programme is completely dynamic so the percentage and the divisor can be different
I have a starting size e.g. 424 which i need to shrink by 40% = 254.4. i then need to dived it by e.g 2 =127.2 .now i need to scale this back up so it accurately represents the divided value of 424/2. if i increase 127.2 by 40% i get 177.8 when correct answer is 212.
i know the answer is probably simple
thanks