Hi Ger - the link to the the post above appears no longer valid. are you able to share again? NB I think I have an old file by you named "shapes measure area 48347_Ger" but I think I may have broken part it. I wonder if that is…]]>

Re: Calculate Polygon Area

Aaron, I updated the code in the thread when calculating the area of the polygon...

http://www.ozgrid.com/forum/sh…d.php?p=322975#post322975

You were right - there was some rounding errors when the numbers were being **displayed** in both the cells of the worksheet and the segment line lengths. These are now fixed (3 decimal places), but the area that the code was caluclating was correct (based on the numbers it had in the node points). So the formula would **appear**to be right

Take note though, that if you rotate a square (or rectangle) through about 45 degrees, the 90 degree corner on the shape becomes either 89.9 or 90.1... this effects the segment lengths and hence the area of the shape, so you will get a slightly different area for a rotated polygon. I am inclined to think this has more to do with how Excel rotates the image as opposed to an error in Andy's trig. calculations for caculating the angles that each line in the polygon makes. It could be fixed by a Round statement, but this is probably introducing a fix for something that is arguably not broken.

Cheers

Ger

Hi Ger - the link to the the post above appears no longer valid. are you able to share again? NB I think I have an old file by you named "shapes measure area 48347_Ger" but I think I may have broken part it. I wonder if that is still available. Many thanks in advance.

]]>Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.]]>

Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.

]]>Sorry moderators for not finding the way of closing this thread (I…]]>

Sorry moderators for not finding the way of closing this thread (I honestly can't find how to close it myself)

]]>Thank you so much, that work well]]>

Re: How to create a button and then rename it using a Macro

Per the Forum Rules, all VBA code must be wrapped in code tags, which you omitted. I have added them for you. Please take the time read and understand the rules, and avoid any infractions that may (will) affect your posting privileges.

You don't need to make a selection to work with the button.

Also, what exactly is your requirement @ 100%?

Thank you so much, that work well

]]>This thread was what I was searching for. I've implemented Cytop's code in my excel workbook and it works like a charm.

At the moment this thread is more than 365 days old, so I hope you will still read this.

My workbook has…]]>

This thread was what I was searching for. I've implemented Cytop's code in my excel workbook and it works like a charm.

At the moment this thread is more than 365 days old, so I hope you will still read this.

My workbook has multiple sheets. Now I have implemented Cytop's code in a module so that every worksheet can call the module for hiding/unhiding the row's. Then if something changes I do not need to change every worksheet code, but only the module code.

I've used the code below to call the module:

It calls the module, but then Cytop's code doesn't work in the module. It only works in the sheet.

What needs to be changed for this to work?

Kind regards,

]]>Need a small help in excel. In a cell I have multiple rows of data which includes text and numbers. I am trying to extract numbers after a specific text for eg :

Data in a cell where I need to run the search say in cell A1:

SUMMARY=…]]>

Need a small help in excel. In a cell I have multiple rows of data which includes text and numbers. I am trying to extract numbers after a specific text for eg :

Data in a cell where I need to run the search say in cell A1:

SUMMARY= AInitial#11

NOTES=

AInitial#11

RCA#=2

================================================================

ID= PIW0

WORKDETAIL_SUBMIT_DATE= 2020-02-20 01:06:27 -0600

TYPE= General Information

Volume#222

SUBMITTER= tp

SUMMARY= AVolume#11

NOTES=

AVolume#12

Search Result

in Cell B1 RCA = 2

in Cell C1 AVolume = 11

in Cell D1 AVolume = 12

in Cell E1 Volume = 222

As per above example i want to extract any numbers after "RCA", “AVolume” “Volume” as shown above. The numbers can be vary in digits i.e. it can be 1 digit numbers or 4 or 6. Also, at times there is some other text in between (like # & =** )**.

Any formula to get result will be helpful please prefer formula instead of VBA, since i am not sure how to use VBA.

Thanking all in advance 😊

]]>do you have an idea of a formula that could help me to detect suspicious phone numbers in excel?

I have a list of phone numbers each with 10 digits.

I am trying to detect numbers that might be fake following the last 8 digits not to be:

a) repetitive…]]>

do you have an idea of a formula that could help me to detect suspicious phone numbers in excel?

I have a list of phone numbers each with 10 digits.

I am trying to detect numbers that might be fake following the last 8 digits not to be:

a) repetitive XXX XXXX

b) consecutive (12345678) or the other way arround (87654321), at least 3 digits consecutive to be considered suspicious

c) patern XYZ XYZ

d) patern XY XY XY XY

e) includes date (XX08202020), so is has the 2020 number in the string.

any idea could help me

thank you

]]>Please read the Forum Rules and you will see that members are asked not to post questions in another member's thread. Please start your own question.]]>

Please read the Forum Rules and you will see that members are asked not to post questions in another member's thread. Please start your own question.

]]>I need to use excel to draw wafer map ,analyze wafer shot focus heat map and some issue ,but I have no idea to finish it ,so have anyone could be help me to finish it?

My raw data only show two wafer all shot data ,but if I have 25pcs wafer(shot…]]>

I need to use excel to draw wafer map ,analyze wafer shot focus heat map and some issue ,but I have no idea to finish it ,so have anyone could be help me to finish it?

My raw data only show two wafer all shot data ,but if I have 25pcs wafer(shot in the same position ,but focus not the same) ,how to draw it

]]>https://docs.microsoft.com/en-…alheight?view=netcore-3.1]]>