I have this code and when I try and run it I get Run time error 9 subscript out of range.HTML Code:
anyone know why?
you should know that I did have another reduction start sheet that I deleted afer copying one from another workbook.
I have this code and when I try and run it I get Run time error 9 subscript out of range.HTML Code:
anyone know why?
you should know that I did have another reduction start sheet that I deleted afer copying one from another workbook.
Which line does it highlight? - run it and when it chokes click on debug and hover over the highlighted variables - then you'll at least know what the problem is
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
It highlights just below select case target case "next tap 1" on the set DWS sheet (Reduction Start)
See if "Reduction Start" sheet name has extra space or misspelled.
Other than that why are you using .End(3)?
There is no such constants... so it is probably working accidentally...
constants for xlUp = -4162, so you'd better use one of those.
I'm afraid some office updates will finally destroy your code...
not sure why using anything thing. Got the code from the pay portion of this site.
1) Did you check the sheet name?
subscript out of range in this case means vba can not find the sheet named Reduction Start.
2) I recommend to replace (3) with either (xlUp) or (-4162).
superchew,
Pease edit your post #1 and replace the [HTML] [/HTML] with [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags.
Please don't use HTML tags to post your code samples.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks