1. auto.pilot

    Seeking VBA method to filter multiple values

    I have the following bit of code which is part of a larger project. Near the top, I have identified TheClient as a single cell reference. Within the code, a workbook is opened, then filtered by TheClient in column A. Thereafter, the headers and filtered range are copied and then pasted to the...
  2. M

    Extract and arrange the numbers small to larger values

    Hello,</SPAN></SPAN> I need to extract the numbers of column E:N and need to arrange them in order small to larger values in the columns P:Y</SPAN></SPAN> Example <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse...
  3. P

    first number (in a list) larger than a certain value

    I have a list in the range ... CM37:CW37 I have a value in ... BY37 I'd like to find the first number in the list range that is larger than the value in BY37. eg: List Range in CM37:CW37 .... <tbody> 199.0 209 219 229 239 249 259 269 279 289 299 </tbody> Value in...
  4. C

    Macro validation before running

    Hi guys Hoping a genius can help me with a quick check before running through a macro... My vba below works perfectly, however can someone please help add some validation before running my macro that does the following check: Cell C9 must contain either the text "RP2000" or "RP5000" Cell C11...
  5. V

    Larger minus smaller equals 0

    I am finding the differences between adjacent numbers in a column. All have been verified by ISNUMBER enquiry. The answer is always 0, no matter the format of the answer cell. Please! Why this happening and what's the solution?
  6. B

    Minimum Value of 1.00 in Cell

    I have a cell that does not have a formula, but i need it to have a minimum value of 1.00 in it. it can have larger number in it, but no lower than 1.00, it must always have a value in it. Thanks for the help Chad
  7. I

    Vlookup - finding a value in more than just the left hand column

    Hope someone can help with this. I have data arranged like this - ID1 ID2 ID3 Data1 Data2 45 56 89 aa dd 67 bb ee 91 78 cc ff I need to get the data arranged like this - ID ADD1 ADD2 45 aa dd 56 aa dd 67 bb ee 78 cc ff 89 aa...
  8. G

    Can Cols.Width be forced to larger size below range and above smaller size or simlated

    Hi everyone, I am wondering if it’s possible to set column widths to a wider size than the above, using say a range, meaning if the range A1-A17 = column size 10.00 then have A18 –A100 = column size 20.00, I don’t wish to use merge cells or wordwap if possible. Or if not at least simulate...
  9. M

    Count all values of each row from smaller to larger

    Hello,</SPAN> I want to count from smaller to larger valve of each row and put them in one cell separated by vertical bar. Is it possible?</SPAN></SPAN> As per example below</SPAN></SPAN> <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  10. J

    Chart Export to Image

    Hi, I have code to export a series of charts from a dashboard to images. The intention is to then disply them on TVs around the building I have code that will do that (HTML) but the charts are tiny :( They are nicely laidout for the dashboard but I need larger images for the TV Is there a...
  11. auto.pilot

    Seeking method to name a worksheet, limited to 31 characters

    I have this small bit of code which is part of a much larger project. It simply re-names each worksheet to the value of cell B1 on that sheet. For Each ws In ActiveWorkbook.Worksheets ws.Name = Range("B1").Value Next ws Today, I came across a value in cell B1 that is...
  12. M


    Hi there I have two sheets. In the first sheet I have summary data where I have a column of dates/times, and I've used an IF statement to find the closest time from the second sheet,which is much larger. The statement is of the form: {= MAX(IF(Sheet2!$C$:$C$13144<sheet1!a2...
  13. W

    Display a symbol based on a value being higher then/lower then or equal

    I am trying to display a symbol based on the condition that a cell is larger then/smaller then another cell, if larger or equal to then I want to display a ✓ and if the cell is smaller then I want do display a ✕. Also if one or both cells are empty, 0 or "" I want to display a ✕. Finally, I...
  14. D

    vba error when copy/paste without clipboard

    Hello all - I'm receiving a "missing object" error in the below code. This is only a smidgen of much a much larger code which copies 100 text files into 100 worksheets. The range in File2 may vary, but will never be larger than A1:R55. Any assistance in having this copy/paste without...
  15. B

    Column Width

    Have a data set which results in column widths required to be set at a specific width. Is there a way to perform this task, the data can extend to many more than the example below. Auto fit does not work since the data in some cells may be larger. example Range("A1").ColumnWidth =...

Some videos you may like

This Week's Hot Topics