function as range

Hi everyone I have written a custom function that takes 2 arguments as strings - when the function is called ordinarily it works absolutely fine. However, when I call it within a double-loop it does not recognise the strings in the cells - I have tested the loop using a counter and know it...

I am trying to create a formula that does not exceed 160% and 40% I am using cells E6 (Numerator) and G6 (Denominator). I would like E6/G6 to = 80% and it to not exceed 160%. I plan on using the percentage "number" option to add to the aesthetic appeal. In addition I would like to another that...

Hello. I have a question...if i want to create a custom format where text is center aligned, middle aligned, and applying text wrap when info is created into the cell how do i do that? i'm trying to automate it to do this. Also, how can I automate when info gets inserted into a cell the...

Hi :) I have a graph in an excel sheet that depends on several formulas and data... What I need is a code or a formula which asignes Cell B38 the Maximum of the function in the chart ?? Can anyone help me with this?? Thank you!!

Hey all, I'm having difficulty with some basic syntax. I have the code below to find the last row, and then just below that, the code that I am using to try and select everything from A2:U2 down to the lastrow. Help? any ideas? Function xlLastRow(Optional WorksheetName As String) As Long...