HI ALL !! THANX FOR HELP.... I AM GETTING ERROR TRYNG TO INSERT THIS FORMULA THAT BY ITSELF WORKS PROPERLY IN THE WORKSHEET...
ERROR 1004
Sheets("LList").Range("NH1").Formula2 = "=IF(LList!NA1="","",IFERROR(LList!AA1*((LVar!$G$2-MIN(RT!$H$1-LList!NA1,LVar!$G$2))/LVar!$G$2),""))"
Is there a reason to use .Formula2 ?
Have a try with:Note the extra quotes.
Please Login or Register to view this content.
Difficult is not to know but to share what you know (Han Fei Tzu reworked)
yes !! i knew it was about quotes..
but didn't remember how to solve ty !!
Thanks for the positive feedback, glad having been of some help.
for easy using chr(34) > translate every quote in cell of sheet to chr(34)
Please Login or Register to view this content.
Last edited by daboho; 05-14-2024 at 09:21 AM.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
ok !! tyvm !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks