Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a standard row through VBA
Who is able to help?
I try to make a piece of VB-coding for copying and pasting lines, but I cannot manage to hold the line-number in memory. This is the case: I try to copy-paste (insert) a line on the row of the active cell. This lines that has to be copied is a standard line on a standard location. It has to be this line because of some formulas involved. So imagine that I have an active cell on row 19 and I have to insert here. The line to be copied and pasted is on line 6. I will have to save the row-number in a varianle, because I will have to perform this action not only on the active sheet, but on some other sheets as well. (The line to be copied is on the same row-number and has to be inserted on the same row as on the first active sheet). How can I (in VBA) record the row number (and only the number)? In my example I mention row 19, but this could also be row 20, 15 or 96. Thanks for the attention and reply for this problem. Remco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a standard row through VBA
x=activecell.row
" skrev: Who is able to help? I try to make a piece of VB-coding for copying and pasting lines, but I cannot manage to hold the line-number in memory. This is the case: I try to copy-paste (insert) a line on the row of the active cell. This lines that has to be copied is a standard line on a standard location. It has to be this line because of some formulas involved. So imagine that I have an active cell on row 19 and I have to insert here. The line to be copied and pasted is on line 6. I will have to save the row-number in a varianle, because I will have to perform this action not only on the active sheet, but on some other sheets as well. (The line to be copied is on the same row-number and has to be inserted on the same row as on the first active sheet). How can I (in VBA) record the row number (and only the number)? In my example I mention row 19, but this could also be row 20, 15 or 96. Thanks for the attention and reply for this problem. Remco |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a standard row through VBA
How such a simple solution is the answer to my problem.
Thanks excelent excelent wrote: x=activecell.row " skrev: Who is able to help? I try to make a piece of VB-coding for copying and pasting lines, but I cannot manage to hold the line-number in memory. This is the case: I try to copy-paste (insert) a line on the row of the active cell. This lines that has to be copied is a standard line on a standard location. It has to be this line because of some formulas involved. So imagine that I have an active cell on row 19 and I have to insert here. The line to be copied and pasted is on line 6. I will have to save the row-number in a varianle, because I will have to perform this action not only on the active sheet, but on some other sheets as well. (The line to be copied is on the same row-number and has to be inserted on the same row as on the first active sheet). How can I (in VBA) record the row number (and only the number)? In my example I mention row 19, but this could also be row 20, 15 or 96. Thanks for the attention and reply for this problem. Remco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
standard deviation | Excel Discussion (Misc queries) | |||
Inserting a 'Standard' | Charts and Charting in Excel | |||
standard form | Excel Discussion (Misc queries) | |||
Standard Modules in VBA | Excel Programming | |||
Standard Error | Excel Worksheet Functions |