Currently getting this Run Time Error With:
Any Ideas why??Please Login or Register to view this content.
Thank You
JRidge
Currently getting this Run Time Error With:
Any Ideas why??Please Login or Register to view this content.
Thank You
JRidge
Where are "file" and "file1" defined and what do they contain?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Solved
Please Login or Register to view this content.
Please Login or Register to view this content.
My problem is now:
Basically instead of pasting the value 11 columns to the right of c i need to:Please Login or Register to view this content.
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
You have the advantage of knowing what your workbook, worksheets and data look like.
Yeah i suppose
Doesn't help me work out how to code this part though
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
As an example:
Please Login or Register to view this content.
Regards, TMS
Got around it by using this:
Get the column number when i paste the name in earlier in the script.Please Login or Register to view this content.
Then:
and it works tooooPlease Login or Register to view this content.
Regards
JRidge
Thank you for sharing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks