hi thankyou for your reply.
i am runnung a macro in vba. Its quite a long macro and takes a while. I would like to minimize the window (excel) and monitor its progress in a seperate window (maybe something small in the corner of my screen). I know how to do it in a userform, but i would like to...
across row 1 I have company names starting at b1. Down column A I have stock names starting at A2. After working things out on a seperate sheet i calculate a number for the cell b2 . I then calculate a number for b3 etc etc . Now column b is filled. I do the same for column c, d etc etc till the...
i have data in sheet1 with a list of companies from A1:A300 and some more companies form A1:CY with a whole load of numbers in between.The numbers are between -1 and 1. how can I code it so that given a value, say 0.8, the spreadsheet will give me all the numbers above it in a seperate sheet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.