ytjjjtyj
08-02-2019, 01:01 PM
Hello I really need help. :(
Nothing is working but I will explain what I am trying to do.
In "book1-VBA" I am trying to see if the numbers in column D are equal to or over 24. If they are, then put it in a variant and round UP the value in that row in column B then round DOWN the value in that row in column C.
After that is stored in a variant I want to close book1-VBA and open book2-VBA and get the start and end time numbers and the numbers between them to match the number in my named range in book2-VBA called "MyNumbers". If it matches- then remove the highlight to be white. If there is no match, then do nothing.
Can anyone give this a shot? Thank you in advance.
(If there is a better way to do this without storing in a variant and then importing it to make it useful I would be happy to hear it. )
Nothing is working but I will explain what I am trying to do.
In "book1-VBA" I am trying to see if the numbers in column D are equal to or over 24. If they are, then put it in a variant and round UP the value in that row in column B then round DOWN the value in that row in column C.
After that is stored in a variant I want to close book1-VBA and open book2-VBA and get the start and end time numbers and the numbers between them to match the number in my named range in book2-VBA called "MyNumbers". If it matches- then remove the highlight to be white. If there is no match, then do nothing.
Can anyone give this a shot? Thank you in advance.
(If there is a better way to do this without storing in a variant and then importing it to make it useful I would be happy to hear it. )