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

When you used the macro recorder to see how VBA selects a row, did it use Range.Select ?

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 )"

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