inserting

I got a question answered and then I posted another question in the same thread. I forgot I needed to post new questions in new threads. I get an error with trying to insert the following formula into a cell in vba. .Range("M11").Formula = "=IF([@[Wait Time/Hrs]]<3,3,[@[Wait Time/Hrs]])" The...

Afternoon all; Hoping someone can help me with what im sure is a simple problem. I have an excel SS that has roughly 100 columns populated with data. However I need to insert a column starting with column D and then automatically inserting a new column every other column after that. E.g insert...

Hi all, I'm a very new VBA user, so this question might seem a little simple and obvious. When recently looking for code to create blank rows based on cell values, I noticed that all codes read the rows of data from bottom to top, inserting blank rows above the rows already there instead of...

Hi, is it possible when I click on a cell it inserts the current date. I do not want this to update on every cell. Thank you

Excel 365 kept crashing on inserting a template. I think i have tracked it down that you can no longer have more than 2-3 folders in templates. Soon as you have more it crashes Anyone know of fix or workaround

Hello, I am using the row/index function to insert values from another sheet when certain criteria are met. Unfortunately, I’ve noticed that the formula seems to only shift cells down in that column whether then inserting an entire row for the value. Is it possible to adjust the formula below...

Hi, I know there are a lot of discussion on inserting static date using vba, but I need something different. i need one that would insert a dummy date whenever the next cell is empty. to be more specific, I need a code to reflect the date of the respective surveys in the respective column...

Is there a way to insert the names of the sheets into formulas. for example on sheet 1the formula is A30 has if(a2<a50game,if(a5>49,"***","" There are hundreds of cells with formulas, and want to know if there is a way to have the formulas updated to...

Hi, I'm looking for a way to seperate sets of bars in a graph. I've been inserting a gap by inserting a column between the data, which isn't ideal. Is there a 'proper' way to do it? A tick box or something?!?! Thanks!

Hi. there are lots of videos online teaching gantt chart with scheduling (by hours and minutes). but I haven't found anything about inserting break hour (lunch hour) Is this doable? can anyone guide me where to find it? Thanks

Hi, I'm wondering if it's possible to have a 2x2 array of random values inserted into the centre of a 6x6 array of zeros. 0,0,0,0,0,0 0,0,0,0,0,0 0,0,x,x,0,0 0,0,x,x,0,0 0,0,0,0,0,0 0,0,0,0,0,0 I also need to be able to extract the 2x2 array from the 6x6 array for use later in the code...

I have a workbook with multiple worksheets and there are formulas throughout. I am now trying to create another formula which is a simple divide of cell C3 by cell E3 (both are formula driven) and I get a 0 (zero) return. I have tried inserting a new worksheet, no help. I have tried inserting...

I have a Lenovo laptop, and I find myself inadvertently inserting characters into my spreadsheets. I have already disabled the trackpad, and use only the red dot in the middle of the keyboard for moving the cursor around, but I still find all types of unwanted characters. I have Undo in the...

We receive a monthly workbook from a service provider which has VBA code that prevents their users from inserting or deleting rows and columns. However, once we open the file it prevents us from inserting or deleting files in our separate workbooks. What type of code would cause these...

Hello! I have a document with about 20 rows and in two of the columns i have images and text in the rest. I have made sure the images is completly inside a single cell and that the "Move but don't size with cell" is ticked. There is also no consistency to which images move or how far, some...

I have a simple formula. =$n5*sheet2!$V10. When I insert a column in sheet 2, my formula changes to =$n5*sheet2!$W10. How do i keep the formula constant when inserting a column?

I want to insert in a cell a text "Saturday" and "Sunday" but I find it difficult to find the pattern inserting it. Thank you for your help.

I am having difficulty a code that provides for inserting a row when there are to FALSE that fall consecutively. I would like to insert a row when this shows up. Do I use AND IF statement? The True/False column is M on my spreadsheet. Lastrow = Worksheets("APR ADJ").Cells(Rows.Count...

I currently use the following formula to filter an array when the value in I2 is equal to a cell in the named range FILTERRANGE. IFERROR(INDEX(DATA!A$2:A$40,SMALL(IF(FILTERRANGE=FILTERED!$I$2,ROW(DATA!A$2:A$40)-ROW(DATA!A$2)+1),ROWS(DATA!A$2:DATA!A2))),0) I now want to filter the array based...

Hi all, I am writing a macro that inserts new columns according to user input. However I come up with an error message when using the user input in the code: (Code) colLetter = InputBox("Please enter replication factor column:", "Factor column") MsgBox colLetter...