thing

I have written a code to automatically update the width of columns based on what is in a particular range of cells. See the code below. Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Cells.Range("A10:DC49").Columns.AutoFit For i = 1 To...

I am trying to conditional format a row to accomplish this. I need cell A1 when it contains the text “Sell” to fill color, Cells (A6:A10) to turn lets say Green. Every thing I have tried so far has failed, this is just one of several formulas I have used IF(C6="Sell",IF(B6:B10)) Thanks in...

Hi I'm trying to put a DatePicker in my sheet in Column A. I've used the tutorial below to do that. https://github.com/Amallard/excelTricks/blob/master/DatePickerToCells.md However, I need the datepicker range to start in column A from Cell 2 so that it doesn't mess up the table header. Here...

Simple question: Why is my Chart Tools Layout Tab missing? I want to add high-low bars to my chart. I read around to find out how and I find I should click anywhere on the chart and the Chart Tools thing will pop up with three choices under it: Design, Layout, and Format, and I should choose...

Hello In a cell I have: § June Target [] I want between the [] to display the number of a different cell that has a formula. However, the whole thing breaks, any idea?

all the links stopped working to day 14/2/19 when i click on a hyperlink i get the message. cannot load the data to open. I have a file with 400-500 link to facebook pages. only about ten of them follow the link. big help i have tried every thing. thank you Frank Rowley

Hello i need your help : At work we need an excel file whit a comment photo for each thing as you can see in this example: https://imgur.com/a/kwSobuM To do this we use this macro : Sub PictureInCommentSize() With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect =...

I have a formula that says if a cell= "" then "" - for example if in cell C1 I had the following =if(A1="","",B1) The problem is it is not reading cell A1 as being blank even though it appears to be empty. It is in "general" format. The weird thing is it was working a few days ago but now it...

Hi, to all! I need to special unpivot some data. Input: <colgroup><col span="3"><col><col><col><col><col><col></colgroup><tbody> NAMEA NAMEB NAMEC DATE THING 1 DESCRIPTION DATE THING 2 DESCRIPTION 2 DATE THING 3 DESCRIPTION 3 Name1 Name28 Name55 28/01/2019 Descript 1 24/02/2019 Descript 28...

Using Office 365 Excel I enter into Immediate BoxDir ("E:") and I get back "180601 Temp RIBBON CALLS.BAS" which isn't even a file in E:. I add Dir ("E:*.*)"and I get bck the same thing. If I useDir("E:*.Bat") Nothing shows but there is one "*.Bat" file in the directory. Any idea of what's...

Below is the code I am using (I know, not very sophisticate, but the best I know how to do). Two Problems 1- I would like to copy the values (not the formulas) AND formatting from sheet "Prod Runs" to "Sheet 2". As it stands I get the values but lose the formatting. 2- "Sheet 2", "Row L" has...

So I've been working on a macro for my personal use really and I added some errors with MsgBoxes to prevent myself from making a silly mistake. The thing is I have two different erros in a row (consecutive errors) and I want to show just one of the MsgBoxes. Instead of that I'm getting one...

I'm automating the import of a particularly large CSV file. This file is generated by the user, and I want to validate that it is in the correct format (column order & names) before continuing the macro. Ideally, I'd like to read the header row from the file before committing to opening the...

Hello, Normally if we have a table such as <= 5 A >5 B >10 C So if I have a number 6, it will give me B. We all can use Vlookup for this range thing. However, if I have an IF formula like below, I can not translate it into a Vlookup one: =IF(A1>10, (A1-5)/200...

I have created a questionnaire that consists of around 100 questions. These items are separated into 6 domains where. For the sake of easier understanding, let's just call them Domain 1 - 6. I have them typed in one specific table called "Correspondence", with format like below: <tbody>...

Hi Experts Got another problem to resolve I want to filter my records for dates before 10 yrs from today. So I have written following code, which is not working. There must be some technical thing, I'm missing upon. Further, my system use date as dd/mm/yyyy Please help Thanks...

Hi, I have a bunch of cells with either a value, eg "x" or nothing, eg "". I am having a lot of difficulty getting started on an algorithm that iterates through each row (starting A1, going to H1, then jumping to A2 and repeating the same thing), merging-and-center'ing based on the values in...

Hi I'm new to this site & hope I'm posting correctly. I am using this formula it's working fine as long as the data I'm working with is on the same sheet =if(right(d2,1)="r",d2,d2) Now I need to look at a new sheet in my workbook to do the same thing, this new sheet has 1000s rows & columns. How...

Hey, guys, I'm really going crazy with this as I have not been able to figure it out for a couple of days. Let's take the following picture as an example: I'm basically looking for a formula on input on column D which does the exact same thing but with one exception. Let's say we on row 21 we...

Hello knowledgeable users! I am trying to fix a series of numbers. in E2 it reads: 20180809173450Z I want it to be: 08092018 This is what I have so far: =MID(E2,7,2)&LEFT(E2,LEN(E2)-9) Which returns 09201808. Ok almost there, just have to do that same thing to put 08 in front of the...