writing

Hi, I'm not sure if if this can be done, but i figured I'd ask. I have code that opens another workbook and changes data, which generates a userform that you must then click OK for the code to continue running. Is there a way to "bypass" that userform, by writing code that will click the "OK"...

Hi, when i write date/time to a cell like this: Range("G2").Value = Now it outputs like: 19/09/2018 01:32:24 which is correct but im wanting it to display time only. I need the date for various calculations so cant just use Time() function. I can manually set format to hh:mm after writing to...

Hi I'm using a countifs function where there are 3 arguments. One of the arguments i'm asking it to look at is a date and if it falls in a certain month and year then it counts it as long as the other arguments also qualify, how do i go about writing this into my formula? Any and all help will...

Hello all - I'm looking to see if it's necessary for me to go the route of writing a macro for this project. I have about 150,000 lines of data monthly. Each line contains division, branch, manufacturer, supplier, part number, Internal number and price. There are about 20 divisions, 500...

Hello all, So I am just starting to venture into Excel VBA and I have been able to patch some things together with the help of this site, but I am now stumped as to how to resolve this one issue. I have a large report that has the workshop segments for a specific student registered that semester...

I'm sorry, I'm new to writing macros. I'm ok with recording them, but writing is different. I have some macros in a workbook, and if I save it as a different workbook, it won't find the macros when I've assigned them Quick Access Toolbar shortcuts. I must be missing some code...

As the title of this post suggests, I'm trying to use VBA to write some data into another workbook. I did some looking on the internet and this is what I've found. This code doesn't crash, but it sure as heck isn't writing the data to anyplace where I'm expecting it! Not sure what bearing this...

Hello guys, I am trying to set a formula. The formula that I need Is something: If F5 is one stuff here, G5=to the corresponding stuff in the table below. F5 is the cell with multiple choice the formula has to be insert in G5, were actually there is 160. Thank you.

I am a professed excel noob and so I need help writing this function. I need to write a function where a column of values will subtract from an original value until the value reaches zero. If my original value is 125, I need the following table to look like this <tbody> B1 20 B2 20 B3...

What is the difference between writing your VBA code within the worksheet itself vs having it saved in a module (or class module)?

Is there a simpler way of writing this IF statement? =IF(MONTH(B3)=7,11,IF(MONTH(B3)=8,10,IF(MONTH(B3)=9,9,IF(MONTH(B3)=10,8,IF(MONTH(B3)=11,7,IF(MONTH(B3)=12,6,IF(MONTH(B3)=1,5,IF(MONTH(B3)=2,4,IF(MONTH(B3)=3,3,IF(MONTH(B3)=4,2,IF(MONTH(B3)=5,1))))))))))) Thank you!

Good morning, i'm writing a simple formula that substract 2 values if a cell is not blank & Excel keeps-on guiving me errors...this seems simple, but i'm not sure where the error is located? Dim FormuleDonnee As String FormuleDonnee = "=if($G21<>"";$J21-$G21;"")" Range("o21").formula =...

Could you help me how to write VBA to open file which have password for writing. So I would like to open this file only for reading. Thank you.

Hi there, I've got a formula: SUM(A1*B1, A2*B2, A3*B3, A4*B4, etc..). Is there a more elegant (or better practice) way of writing it or is this the best approach?

I have a formula: SUMPRODUCT((PaygroupCode=B2)*(Nationality= {"Nepal","Sudan","Chinese","Japanese","African","British","American"}) *(TotalSalary)) My Query: How can I put the: {"Nepal","Sudan","Chinese","Japanese","African","British","American"} in a list and name it in the "Name Manager"...

Hi I'd like to create a function which returns the number 1 if the TEXT of a cell in the preceding column is red. Is it possible to do this with VBA? I was thinking of writing something along these lines, but would appreciate any pointers! Thanks in advance. Function FontDetect()...

I'm running into a challenge with an "if And" formula. What I want to do: If BV4 = .46, then 0 else if BV4<.46 and AT4<5 then vlookup BV4 to the Rate table else 9 Can you help me figure out what's the issue? Its returning "False" =IF(BV4=0.46,0...

So, I have a bunch of conditions, that based on those conditions, an inputbox writes to a different cell. Instead of writing the code over and over, I figured I would: If _______ then capCell = Sheets("SheetName").Cell(5, 5) end if If ________ then CapCell = Sheets("SheetName").Cell(5.8) etc...

Excel can display 16,777,216 colors. 4,096 squared. How would I go about writing a macro that would show every 4,096th color?

I have a sheet that has sales data from 2015-2017 listed by day. What I would like to do is filter the data and then pull out data for each day within the filtered data. I don't think Sumifs will work since it looks at the entire range. I have read that subtotal would work, just not sure how...