Second attempt to change it, hopefully this time.
Second attempt to change it, hopefully this time.
Last edited by julhs; 02-19-2017 at 10:01 PM. Reason: Thread title change
Post your workbook first.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks mehmetcik
But getting Compile Error – Expected list separator or) at “:AJ”
Have uploaded WorkBook now as JeiJenn suggested
If I understand correctly, this is probably what you are looking for
Please Login or Register to view this content.
Last edited by JieJenn; 02-19-2017 at 09:00 PM.
Hi mehmetcik
It was an extra " before LR1+1
JieJenn
There is a formula in "N", the new row has it in, but seems to have been stripping from original LR1
P.S JieJenn, my mistake I failed to copy ".Cells(LR1 + 1, "N").FillUp"
Thank you both
Last edited by julhs; 02-19-2017 at 09:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks