larger

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...

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...

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...

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...

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?

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

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...

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...

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> Book1ABCDEFGHIJKLMNOPQRS12345n1n2n3n4n5n6n7n8n9n10n11n12n13n14Count Smaller to...

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...

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...

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...

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...

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...

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 =...