1. D

    Inserting table column name into excel formula

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

    Automating inserting columns

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

    inserting rows - above or below current lines

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

    Inserting date

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

    Excel Crashes inserting Templates

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

    Row Index Function for entire row

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

    Inserting date

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

    inserting Sheet names

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

    Gaps between bar sets in graph

    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!
  10. V

    Charting issues

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

    2D Array in a 2D array

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

    Cell Returns Zero On Formula Entry When Values Exist In Dependent Cells

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

    Problem inserting unwanted characters

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

    VBA code not contained in intended workbook

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

    Inserting cells shifts images to other cells

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

    absolute reference is changing when adding a new column

    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?
  17. S

    Writing VBA for Inserting Text in a multiple cells.

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

    Inserting a row inbetween consecutive conditions - Need Help VBA

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

    Filter array with 2 conditions

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

    Inserting user input into Macro inserting new columns

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

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back