Run Time Error 9 - Subscript out of range

[JRidge]

Currently getting this Run Time Error With:

Please Login or Register  to view this content.

Any Ideas why??

Thank You

JRidge

[TMS]

Where are "file" and "file1" defined and what do they contain?


Regards, TMS

[JRidge]

Solved

Please Login or Register  to view this content.

[JRidge]

Where are "file" and "file1" defined and what do they contain?


Regards, TMS

Please Login or Register  to view this content.

[JRidge]

My problem is now:

Please Login or Register  to view this content.

Basically instead of pasting the value 11 columns to the right of c i need to:

Find the Column with File1 value in.
The value is then pasted where the c Row and the File1 Column intersect.

Any Ideas would be greatly appreciated..

Regards

JRidge

[TMS]

You have the advantage of knowing what your workbook, worksheets and data look like.

[JRidge]

Yeah i suppose

Doesn't help me work out how to code this part though

[TMS]

How many choices do you have? One column? Two columns? More than two columns? Lots of columns?

One thought would be to assign the entire data area to a two dimensional array. You can them loop through the array with x and y co-ordinates until you find file1. Then you can use your x and y co-ordinates as an offset to the base cell address. That'll give you your starting point.

The loop should be relatively quick regardless of the number of rows/columns as it's all in memory.

Regards, TMS

[TMS]

As an example:

Please Login or Register  to view this content.

Regards, TMS

[JRidge]

Got around it by using this:

Please Login or Register  to view this content.

Get the column number when i paste the name in earlier in the script.


Then:

Please Login or Register  to view this content.

and it works toooo

Regards

JRidge

[TMS]

Thank you for sharing.