Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert blank cells with VBA?
I run a comparison between column A and column H. Sometimes column A has the
same number, with different data in column B. I need to insert and move down 6 cells beginning in column H. Is there a function or VBA code that can handle this operation. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert blank cells with VBA?
I'm not quite clear on your request:
I run a comparison between column A and column H. 1. How do you run the comparison? I need to insert and move down 6 cells beginning in column H. 2a. What do you want to insert? Data? Rows? Cells? 2b. I don't understand "beginning in column H". On Nov 26, 8:55 am, Face wrote: I run a comparison between column A and column H. Sometimes column A has the same number, with different data in column B. I need to insert and move down 6 cells beginning in column H. Is there a function or VBA code that can handle this operation. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert blank cells with VBA?
Sorry, I import or link data into a single spreadsheet. The data should be
identical from both sources, but .... due to errors, I/we have to run analysis on both sets of data to confirm no errors. In columns A thru F is data from one source and columns H thru M is data from the second source. Columns A and H are flight/mission numbers. Periodically, adjustments occur to the first source (in column A), but when the adjustments are made they are typically made as 2 separate entries, reusing the flight/mission number. The data from my second source will not allow duplication of the flight/mission numbers, so the entry is adjusted then re-entered. We import or link the data from the 2 sources and I need to be able to keep the flight/mission numbers lined up, by adding space (horizontally). "dan dungan" wrote: I'm not quite clear on your request: I run a comparison between column A and column H. 1. How do you run the comparison? I need to insert and move down 6 cells beginning in column H. 2a. What do you want to insert? Data? Rows? Cells? 2b. I don't understand "beginning in column H". On Nov 26, 8:55 am, Face wrote: I run a comparison between column A and column H. Sometimes column A has the same number, with different data in column B. I need to insert and move down 6 cells beginning in column H. Is there a function or VBA code that can handle this operation. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert blank cells with VBA?
Found the code:
Used as a macro, place the cursor in the row you want to insert blank cells, the Range is the columns to insert blank cells. Sub InsertCells() ' InsertCells Macro ' Keyboard Shortcut: Ctrl+Shift+C ' Cells(ActiveCell.Row, 1).Range("H1:M1").Select Selection.Insert Shift:=xlDown End Sub "Face" wrote: Sorry, I import or link data into a single spreadsheet. The data should be identical from both sources, but .... due to errors, I/we have to run analysis on both sets of data to confirm no errors. In columns A thru F is data from one source and columns H thru M is data from the second source. Columns A and H are flight/mission numbers. Periodically, adjustments occur to the first source (in column A), but when the adjustments are made they are typically made as 2 separate entries, reusing the flight/mission number. The data from my second source will not allow duplication of the flight/mission numbers, so the entry is adjusted then re-entered. We import or link the data from the 2 sources and I need to be able to keep the flight/mission numbers lined up, by adding space (horizontally). "dan dungan" wrote: I'm not quite clear on your request: I run a comparison between column A and column H. 1. How do you run the comparison? I need to insert and move down 6 cells beginning in column H. 2a. What do you want to insert? Data? Rows? Cells? 2b. I don't understand "beginning in column H". On Nov 26, 8:55 am, Face wrote: I run a comparison between column A and column H. Sometimes column A has the same number, with different data in column B. I need to insert and move down 6 cells beginning in column H. Is there a function or VBA code that can handle this operation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert a true blank inst. of a non-blank zero string | Excel Worksheet Functions | |||
How do I insert hyperlinks in blank cells | Excel Worksheet Functions | |||
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
insert blank cells | Excel Worksheet Functions | |||
Macro code to test for blank row and insert blank row if false | Excel Programming |