#1
|
|||
|
|||
Select an entire line (to insert one)
Hi,
I have a macro that reads all the linked files (which are referenced in some formula or other) and stores those in a variable named aLnks. => Then there is a loop going through these line by line with a counter_variable "i"; => To avoid the risk of overwriting anything by filling lines with this new data, I want to select each new line and insert a new one (each time shifting the existing lines downward) => What is the syntax for the SELECT statement I need to select the entire line (I calculate the line depending on the counter like >> (i + 10) << (for i=1, that would be line 11 etc.)) Thanks a lot! Best regards, DataNibbler P.S.: The code >>Range((i+10)i+10)).Select<< outputs the error_message "Missing list_separator or )" with the colon highlighted |
#2
|
|||
|
|||
When you used the macro recorder to see how VBA selects a row, did it use Range.Select ?
|
#3
|
|||
|
|||
Hi,
yes, the code was like >> Range(18:18).Select << That is simple enough - the nr. 18 is in my variable - well, the variable might have the value 5 and I know I have to add 13 lines. <=> But the code >> Range((i+13)i+13)).Select << returns an error. How can I do that? Thanks a lot! Best regards, Officer_Bierschnitt P.S.: That sad smiley should have been a colon and the error_message is "expected list separator or )" |
#4
|
|||
|
|||
Okay,
I made it. I figured out when I select one cell in that row, I can use >> Selection.EntireRow.Select << to - select the entire row ;-) Best regards, Officer_Bierschnitt |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to select and copy to clipboard an entire document except for a paragraph and keep formatting | TD_123 | Word VBA | 7 | 06-16-2015 03:30 PM |
VBA code for Microsoft Word macro — select text and insert footnote | ndnd | Word VBA | 10 | 01-06-2015 01:47 PM |
Can I select the entire second or third level in an org. chart? | blockie | Word | 1 | 08-25-2014 11:19 PM |
How to use an ActiveX Control to insert a multi select listbox in Word | marksm33 | Word | 2 | 01-29-2014 05:21 PM |
Word XP - Can't select line | RogerM | Word | 2 | 03-11-2011 01:26 PM |