Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following code to add data to the next open line on a spreadsheet
Sub AddData( ' Macro recorded 12/8/2003 by Brian McGuir Sheets("input").Range("A20:AB20").Copy Destination:= Sheets("database").Cells(Rows.Count, 1).End(xlUp) .Offset(1, 0 Worksheets("input").Range("A20:AB20").ClearContent End Su This works fine, but I now need to skip columns N, O, and P when adding this data. These are calculated via a formula using data from other rows, and I need to keep this formula in the destination cell for the sake of future editing of data in the actual spreadsheet. How can I still add all the columns to the next open row, but skip the three I have mentioned. Thanks in advance Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Discussion (Misc queries) | |||
Interrupting Calculation Iterations | Excel Discussion (Misc queries) | |||
Interrupting Calculation Iterations | Excel Worksheet Functions | |||
Interrupting A Worksheet Calculation | Excel Worksheet Functions |