I am getting the object required error with this code:
Dim wsDst As Worksheet, wsSrc As Worksheet, tblrow As ListRow
Dim Combo As String, sht As Worksheet, tbl As ListObject
Dim lastrow As Long, DocYearName As String, Site As String, lr As Long
Dim RowColor As Long...
I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact...
Why do codes A & B below give me an Object Required (424) error (A is assigned to a button, B obviously fires on WB open) but C works without any issues?:
ComboBox1.Value = ""
ComboBox2.Value = ""
Private Sub Workbook_Open()
Dim ROWC As Integer
ROWC = Worksheets("JOB...
I have B2:B10 which are dynamic cells & keeps on UPDATING (based on time criteria)
Corresponding MAXIMUM & MINIMUM values required in E2:E10 & F2:F10
Code required to accomplish.
I am using Excel 2007.
Thanks in adv.
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col...
HI every one,
i need a small logic if any one can help it will be very great full to me.
B2 gets updated by values due RTD
B3 I have kept a flag which becomes 1 for a certain time period (ONLY ONCE DURING A DAY)
B4=HIGHEST VALUE of B2 when B3=1 else 0
B5= LOWEST VALUE of B2 when B3=1 else 0
How to accomplish?
Thanks in adv
Thank you for any help in advance. I'm still trying to learn VBA and have been trying to figure this out for a while - and need some help.
I am trying to make certain fields required before the user can access the print button I created using the form tools on a specific worksheet. To...
I have a worksheet that I enter data into each month.
At the end of the month I would like to make a copy of the page or the values entered into it then clear the cells & start over again for the next month.
The required advice is how should I go about creating a copy / saving a copy etc...
Hi - I have a report that spits out false info. Due date (F) populates 2 dates. In this case there are 4 x 27/06/19 that shouldn't exist. This in turn means the WIP Qty is 4 numbers short (I).
How can I push (I) down everytime it finds the wrong date? That would also depend on Job # (C) being...
I have some data that I need to flip and copy & paste vertically based on the value at the intersection of a row & column. Below is the data as it is currently & how I need it to look. The result is based on where the policy is marked as 'Required' for that job & policy. I have tried various...
Hello. I am new to forum, a novice in excel and learning VBA. I have a request from my boss to see if I could develop a button that will break up a single spreadsheet "billing" file into multiple spreadsheets to upload into our billing software. The specs would include:
1. A new spreadsheet...
I have hit a roadblock in the progress of my VBA project. I am reaching out to a second group of pros to see if perhaps they have a solution after having limited success where I had originally posted my question.
I have two open userforms. userform1 (uf3_group_1) has a textbox (textbox1) in...
I'm working on a code snippet in order to save my useform entry into my Access sheet. The code is
If IsNull(str) Or str = "" Then
DoCmd.RunCommand acCmdSaveRecord -- line that is highlighted when code errors out...
Hello, I have a a big list of varying numbers and I need to calculate how many are needed to reach the next 100. eg
145 result needed would be 55 (next 100 is 200)
23 result needed would be 77 (next 100 is 100)
412 result needed would be 88 (need 100 is 500)
I've got around this by sorting...
I have the following code to print, but would like to add a number from a cell so that it prints more copies if required. Can anyone help ?
Is there a way to save a .csv file with the required formatting? I need to enter "0000" in a range of cells. When the .csv file was open on my computer, I formatted the range for text so I could enter the required "0000" in the cells. I save the file and sent it to someone else, but...
Excel 2010CDEFG1NameInvoice NoDuplicate invoice2Peter Paul121245no3PeterPaul121245yes4Tiffany5675225yes5Macy5675225no6Tiffany5675225yes7PeterPaul121245yes8PeterPaul1524456NoSheet1
If name in column C and Invoice No in column E appears more than once, required result in column G...
Just a bit of a general info required really.
At work I have read only access to 2 work books. Both of these are staff rotas. There are a myirad of shifts, shift lengths, shift times etc etc… Both these workbooks are just filled in manually with no useful information extracted...ie when...