accept

Hi all , I am new here please help me to complete my exercises Write a macro which accepts a number and checks how that it is the a direct product of how many numbers 64 = 2^6, 4^6, 8^2

I try to set up Const C As String = 2019.2020 , but the will only accept 2019/202 Please advise on how to overcome this

Hi I want to generate random time. So what I tried is that A1 = 24:00:00-rand() But I got error message but when entered the 24:00:00 in A1 and then in B1 I did this B1 = A1 - rand() Excel accept that! Why is that? Thank you.

Thank you for viewing this...I hope you can help me. I am accessing a remote database via ODBC and therefore prefer to use make table queries so I can easily export or reference my results. The problem I have is that when the query is done I only have a short time to accept the dialog box that...

Hi all! I have a range of cells, say A1:F30 where I want the users to be able to enter the characters 0 to 9 a colon [:] only. The cells are formatted as [h]:mm and the colon will always appear in between the numeric values e.g. 1:15, 2:45, 10:05 etc I tried Data Validation with the following...

Hi My computer date setting is mm/dd/yyyy. So I selected a cell and then I went custom format--> dd/mm/yyyy. But when I entered 13/1/2018 excel did not take it as a date/number, it kept it in the left hand side of the cell. But when I enter the date as 1/13/2018 excel will accept it as date and...

Hi My computer date setting is DD-MM-YYYY. So if I enter a date like 13-12-2001, excel will accept that. If I enter date like 1-13-2010 excel will not accept that. So far so good. But why when I enter may 3, 2001 excel will accept that? and why when I type 3 may, 2001 excel will not...

Found a some cool search code. I replicated it in my test workbook, worked fine, which means the "LiftFillRange" accepted the name for the code. =Search!$D$2:INDEX(Search!$D$2:$D$16,COUNTIF(Search!$D$2:$D$16,"?*")) In the name manger its called "search" So I duplicated it in my project and...

hello, I want to use the index-match functions and would like some help. I wrote this function: =INDEX($C$212:$AM$212,212,MATCH(>0,$C$212:$AM$212,0)) I want it to search in the range $C$212:$AM$212 and return the location of the first non zero cell. However, it does not seem to accept the...

Hi Everyone I have created a userform for a financial model that contains a disclaimer. Whilst the userform (disclaimer) is active the excel workbook is not visible. At the bottom of the userform you can either accept the terms and conditions or not accept. When selecting not accept the...

hi i have made a macro code to accept an array from an excel cell. but right now i am not able to accept a value. for ex "Series 1, Episode 4 Including the 1980s story of a campaign for a hospice to be built in the Highlands." from the above example i need to accept series 1 in an array. and...

I'm trying to get a formula working that averages a bunch of numbers based on two conditions. The problem I'm having is that my Average_rng needs to be the sum of two other cells and it doesn't seem to work. Can anyone help? My formula is: =AVERAGEIFS(SUM('Input Data'!K:L),'Input...

Hey i want to Validated a Cell with Only some text. Means the cell only accept some text which i want Like XS-S-M-L And so on The cell which i validated should not accept anything else then that. Can anyone here who can help me out with this Issue.?????:confused::confused::confused::confused:

Fellow sufferers! I just want to make a pie chart from arrays holding the values. Please see my code below, which loads the array review_statae into memory. I want to do something like below. I did lots of googling, never found the right way to do it. Public Function piechart_build(url As...

Hi all, I have numbers in column B, in column C I have =round(b2,2). Then I copied column C and pasted special values into column B. When I add decimals to column B and look at the total number in the lower right hand bottom of the screen it shows my total as 1,333,844.710005000 The system I...

Hi I understand excel will accept a date based on the computer settings. If I have my computer short date set as dd/mm/yy then excel will accept the same format unless i custom formatting it. So If my computer is dd/mm/yy then excel will accept 20/10/2017 but not 10/20/2017 (month can not be 20)...

Hi I have tried to enter same date into 2 different computers. I noticed one computer accepted 1/1/2017 as a date but the second computer did not accept it and the date stayed in the left hand side of the cell. Why is that? Why one computer accepted 1\1\2017 and others not.

Hello I am just trying to learn how to use custom formatting. So I wanted to add a format like #,#5 ### and excel accepted it no problem. Then I tried to add #,# but excel did not accept it; instead excel entered #,###. Any idea why? Thanks

I have a pivot table to which I'm trying to add a calculated field but having no luck. I am trying to check the difference between 2 numeric fields and depending on whether or not if it is positive or negative I want to display 'over' or 'under'. I can get it to accept the formula...

Hello! I really need help on this problem. I don't know how to manipulate the formula with quoting the "You can't have cups less than zero". I really need help on this, please....please... I hope somebody can help me. thank you. God bless. Teletubbies coffee - Nested If Create a nested If...