Hi
I'm trying to get this to be entered into a cell once a form is refreshed in VBA but VBA doesn't Like the ,
.Range("H8") = "=E2&","&E8&","&H2"
Thanks in advance
Hi
I'm trying to get this to be entered into a cell once a form is refreshed in VBA but VBA doesn't Like the ,
.Range("H8") = "=E2&","&E8&","&H2"
Thanks in advance
Last edited by sid6478; 05-14-2021 at 07:43 AM. Reason: solved
Try:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try it this way
Please Login or Register to view this content.
Thanks for the rep.
Hi !
[H8] = [E2&","&E8&","&H2]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks