Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row
Hi, I used someone else's answer below to write code to find something in a
call and when it finds the character it will insert a blank row. But, I have this sheet linked to another sheet where I also want the blank row to show. It doesn't, it just skips the blank row and jumps to the next line. Any idea how to insert a row and have it push the blank to the linked sheet? Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row
It would help to show the code you have so far, and explain how the sheets
are linked. Tim "johnrb7865" wrote in message ... Hi, I used someone else's answer below to write code to find something in a call and when it finds the character it will insert a blank row. But, I have this sheet linked to another sheet where I also want the blank row to show. It doesn't, it just skips the blank row and jumps to the next line. Any idea how to insert a row and have it push the blank to the linked sheet? Thanks, John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row
Hi Tim, here is what I am doing. I have switched from adding a row to adding
cells and shifting the other cells down. I thought that might help but it doesn't. I have the sheet where the cells are inserting linked to another sheet and when I insert the cells the formulas on the linked sheet change to just skip the blank cell. Is there a way to have the cells that are linked hold that absolute value (to the linked cell) even when the originating sheet changes? RowCount = 2 FirstRow = 2 Do While Range("A" & RowCount) < "" If Range("G" & (RowCount)) < Range("G" & (RowCount + 1)) Then Range("A" & RowCount + 1).Select Selection.Insert Shift:=xlDown Range("B" & RowCount + 1).Select Selection.Insert Shift:=xlDown Range("C" & RowCount + 1).Select Selection.Insert Shift:=xlDown Range("G" & RowCount + 1).Select Selection.Insert Shift:=xlDown Range("H" & RowCount + 1).Select Selection.Insert Shift:=xlDown RowCount = RowCount + 2 FirstRow = RowCount Else RowCount = RowCount + 1 End If Loop Thanks, John "Tim Williams" wrote: It would help to show the code you have so far, and explain how the sheets are linked. Tim "johnrb7865" wrote in message ... Hi, I used someone else's answer below to write code to find something in a call and when it finds the character it will insert a blank row. But, I have this sheet linked to another sheet where I also want the blank row to show. It doesn't, it just skips the blank row and jumps to the next line. Any idea how to insert a row and have it push the blank to the linked sheet? Thanks, John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row
Hi Tim, I got it to work.
Thanks, John "Tim Williams" wrote: It would help to show the code you have so far, and explain how the sheets are linked. Tim "johnrb7865" wrote in message ... Hi, I used someone else's answer below to write code to find something in a call and when it finds the character it will insert a blank row. But, I have this sheet linked to another sheet where I also want the blank row to show. It doesn't, it just skips the blank row and jumps to the next line. Any idea how to insert a row and have it push the blank to the linked sheet? Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
Insert new Worksheet with name, and insert the sheet into itsalphabetical / numerical location | Excel Programming | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |