insert

Hi, Is there a quicker way of insert a new row between two adjacent rows of a 600 rows speadsheet? At present we are using click on Ctrl + highlight the row one by one and click on insert? thanks, Peter

Hi everyone, Hopefully an easy one for someone to help me with. Can anyone supply the VBA to insert an image from file into a selected shape this is what the recorder gave me. I would like the user to be able to choose an image from file and not restrict them to a pre-defined name. Sub...

Hi Im trying to insert a blank row below a row that has the word "Ticket Control No." in column S. When I tried doing this manually I get the error message "microsoft excel cant insert new cells because it would push non empty cells off the end of the worksheet" On my worksheeet there is...

I have a line graph that shows the credit rating on a business over the course of the last 12 months. Is there a way to highlight a specific date in the time line other than insert shape?

Hi, Can you advise please the correct way to apply Ucase for when i insert a new row each time at A6:H6 I have this code below but keep getting Run Time Error 13 Private Sub InsertNewRow_Click()Rows("6:6").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Range("A6").Select...

Hi I have a spreadsheet that uses code to insert rows into my table based on a cell value. My problem is the cell value can be over 100 and i would like to somehow break the table up if value is 20. So if value is 20 then start a new table. This is purely for printing purposes (header on each...

Hello, I've been searching with no success. I have 300 rows of data and I'd like to insert 7 new rows between each data point, copy that data point down those new rows, then move to the next data point. This will be done 300 times until I have 2,400 rows of each data point copied 8 times. Any...

Hello, I have a table inside my excel document. The table is pretty large, and has bounds/data range of ($J$1:$BN$3073). I am trying to record/write a macro that will 1. Find the end/bottom of this table 2. Copy the 12 rows that are at the bottom of the table 3. Paste/insert...

Hi I want to insert a formula in the cell left to a check box, if the CheckBoxes.Value = xlOn : Sub test() For i = 53 To 102 If ActiveSheet.CheckBoxes(i).Value = xlOn Then ActiveSheet.CheckBoxes(i).TopLeftCell.Offset(1, 0).Formula = ("=2+2") End If...

Hi, I've got $ figures in range I14:T20, and each respective column has a subtotal formula=SUBTOTAL(9,I14:I20), =SUBTOTAL(9,J14:J20), etc The user can run a macro to insert a line at the bottom of the data which will then be populated with $ figures. My question is, when the row is inserted...

Hi, Can you please tell me the macro used to add 10 columns at K starting at row 50? Basically, I want to move all data from k50 and below, over 10 columns to the right, without moving the data above k50. Thanks!

Hi My spreadsheet has a row of totals where most totals are zero. I have VBA to hide those columns where the totals are zero, but the spreadsheet now looks a bit busy, so I would like to insert a column where the total is greater than zero. So I am looking for VBA code to insert blank columns...

What I am trying to accomplish if is is possible is if the value on the left is within the Range then the Rating on Right will insert Stars 1/ Cell. Is this Possible? Thank you! <tbody> Values Ratings 80-100 * * * 60-79 * * 50-59 * </tbody>

Hi all, I am trying to insert copied cells into another spreadsheet based on the value changing in column A, if it changes the rows are inserted underneath the 1st value and before the 2nd value. What I have currently is the below however I am seeing some anomalies. The codes is activitate...

Hi - I am trying to calculate 200000 minus a number in a cell address that changes when I insert an additional row. For example, 200,000 minus D3. (D3 is the sum of the range D1:D2) but then I insert a row and the calculation has to become 200000 minus D4 (where D4 is the sum of the range...

Hello I'm looking for a macro that will search the whole sheet for 12345 and if found then insert a row above and position the cursor in the Cell A of that inserted row, any help would be appreciated. Thanks.

Hello: I've counted rows in file1 and want to insert 2.25 rows in file2. Everything is fine until row insert statement. I get the error: Insert method of range class failed. I've tried a ton of other iterations and can't get it to work. Any help would be greatly appreciated! Dim wb as...

How to make CTRL+A work to select all the text? Maybe someone have a macro handy?

I work regularly on a particular type of Excel document that requires me to insert images so that my colleagues can understand what I'm referring to (related to mechanical design and a picture speaks a 1000 words as they say). In order to keep the document neat and tidy, I insert comments and...

Hi All I want to insert a row or rows and keep the page break the same. So if the page break is under row 40 and I insert lines, the page break remains under row 40. Is it possible? Thank you!