View Single Post
 
Old 11-05-2015, 08:59 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default 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
Reply With Quote