produces

I have tried every possible combination to resolve this issue and can not find an answer. Ia about to pull all my hair out. most of the code I have tried produces an error. the following code does NOT produce an error...but also does NOTHING. Sub Fix_Font_size()...

I have a fairly simple formula that I am trying to amend so that inserting a line does not cause the cell values to change using the INDEX command. The formula I was using was: =IF(E6>0, E6, 0) Which I have updated to: =IF(INDEX(C:E,3,3>0),INDEX(C:E,3,3,0)) This produces a #VALUE error so...

Hello there, I'm wondering if there's an alternative to COUNTIFS when referencing cells in another workbook. The reason why I'm asking is because SUMIFS and COUNTIFS produces errors when this other workbook is not opened. Thank you in advance!

I have several UserForms with many TextBoxes. To quickly ClearContents I've tried this which produces Object required error. Any suggestions? For i = 1 To TextBox.Count TextBox(i).ClearContents Next I

Hello, A line in my VBA code produces a 1004 error: Application-defined or object-defined error. The code is nearly identical to other code I have but this line keeps giving an error, when on the other spreadsheet the same line does not produce an error. Any help is appreciated, see code below...

for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations. Lottery Basics: 7 numbers from 31. Order does not matter. 03 05 08 09 19 21 30 08 11 12 14 20 21 28 11 12 21 24 25 28 29 06 07 13 15 18 19 29 02...

Hiya Could anyone make any sense of this for me? In cell A12 (which is formatted to return a percentage total with no decimals) I've got the formula: =$F$12/$H$12 where F12=2 & H12 = 79 This returns a total of 3% - which is accurate enough for my purposes. But when I preface that formula...

Greetings, The below formula produces "True" if >= 181 & <= 356, and "False" otherwise. it's in a table. Can the formula be modified to produce 1 if true and o if false? =IF(AND([@[Days Until Expiration]]>=181),[@[Days Until Expiration]]<=365) Thanks

I have the following code which works if the cell doesn't have any value but doesn't work if the cell has a formula that produces no value. What I am looking for is a way to hide the row if the cell is empty or has a formula that produces no value. Is this possible? Guy Sub HideRows()...

Hi All, I need to count the number of unique ID numbers after I use the countifs statement. I have multiple criteria to sort out the data which produces the ID numbers but there are duplicates numbers and then I need to get the number of Unique ID numbers from that criteria data What i have...