Thanks Leith for youe quick response
How do i fix this line to the corrected OR
Thanks![]()
Range("K2").FormulaR1C1 = "=or((RC[-2])=" & currentsheet & ",(RC[-1])=" & currentsheet & ")"
Shark
Thanks Leith for youe quick response
How do i fix this line to the corrected OR
Thanks![]()
Range("K2").FormulaR1C1 = "=or((RC[-2])=" & currentsheet & ",(RC[-1])=" & currentsheet & ")"
Shark
Hello Shark,
What does currentsheet refer to?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith
Currentsheet - is the the month and year MMYYYY 052009
Thanks
Shark
Hello Experts
Can someone know what is the cause of not matching in the attached Excel sheet
Shark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks