cleared

this is running slowing....could someone pls recommend a way to speed this up? im afraid of doing calculation xlmanual....will that mena the loops wont work? Dim chk As String Dim amtc Dim found As String Dim clear_c As Integer 'total record count on "Cleared" sheet...

Hi, ive seen this code before posted in here but cant seem to find it. I have a table with headers in Row 5. In Row 3 i want to use these cells for filtering the corresponding column. Example if entering "green" in C3 then the table will be filtered automatically, then when C3 is cleared the...

I have a macro that clears all of the cells in a workbook before I repopulate them with new data. The first step in the macro clears all of the Command Button captions. I then do an Application.Screenupdating=True I then carry on to clear all other cells. As these are being cleared they appear...

Range("'Exhibit " & """I"" "'!$C$3:$D$3").clearcontents I have a worksheet called Exhibit "I" and inside that worksheet I have various ranges that I would like cleared when this workbook opens. This is just one of many ranges I would like cleared. The above code returns a syntax error. How can I...

sorry for the dodgy title, didn't realise i hadn't finished (Should be "Formula Change on MS Query Refresh") Hi, I have just been given a windows 10 PC with Excel 2016 for testing. I have a problem with a spread sheet that has been working for years. in its simplest form: A5:G100 containers...

Hi All, I've got a problem that I suspect has probably been asked before, but I can't find anything on it, so I'm starting a new thread. I have a series of accounts which need to be reconciled. That is, an account may be made up of hundreds of transactions but the majority of them net to...

Hi i have analysed the data I have to produce a table showing the number of cases received and cleared each month based on converting the date field into months. I now have a problem because the 12 months has gone round and now I have April repeating itself so I need to add the year to the...

Hello, I have several version of a workbook I am trying to implement, as I've added and changed code I've saved in different revisions. Right now I am trying to track down why Conditional Formatting is being cleared from one range of cells on a newer revision of the WB compared to an older...

Hello, I made a macro to go through a long worksheet and clear out all the entries in certain cells, using the following example code <Code> Range("G297").Clear Range("R297").Clear Range("D298").Clear Range("L298").Clear Range("S298").Clear Range("D299").Clear </code> I did this for hundreds...

Hi, I have 6 textboxes numbered 2-7 on a userform. I only want 1 with a value in when I press the command button to transfer the value to the worksheet. If there is a value in 2 or more I'd like the textboxes cleared and a message saying "only one textbox value please" any help would be...

I have a file that in the date it gives me: 4/1/20162, 5/1/20163... I have used every date format imaginable. Copy and Pasted values of new dates, cleared all including formats...and nothing fixes this??? Any ideas?

Hi, I need to reference the specific site name on column B, find out which entry for that site is the most recent from column A and return the value in C (whether it is "cleared" or "raised"). There will be duplicates in Column B (Source) but I am only interested in what the most recent...

I have a spreadsheet with a list of Invoice numbers (which all begin with INVxxxxxx) in column B and then in column C the name of the person who cleared that Invoice. What I need to do each week is do a random check on an invoice that each person has cleared so if "John Smith" cleared 10...

=IF(B7="","",VLOOKUP(B7,ProductLookup,3,FALSE)) this is the formula I am using. I am using it on an order form that will be repeatedly cleared and re-filled in for students during registration. However, when the textbook is cleared from the "Products" column, this error report shows up in the...