hi
a userform has this code
this works fine if range is a2 but if I change it to f2 it has error457 (this key is already associated with an element of this collection)can anyone tell me why
Please Login or Register to view this content.
it will not work please
cheers colin
Last edited by cfinch100; 01-08-2014 at 05:19 PM.
When you debug, is there a specific line highlighted?
If you step through the code where does it fail?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
hi
stops at this
the second time it runs eg goes through code then trys again and stops at thisPlease Login or Register to view this content.
cheers colin
How many rows in column F have data?
hi solus
has 14 rows all populated with text (scrapped) only 14 rows on spreadsheet used at minute
cheers colin
hi solus
have eventually solved this myself was all to do with the formatting of the cells on the spreadsheet , changed format to text and hey it worked
many thanks for looking
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks