christian2016
Board Regular
- Joined
- Oct 6, 2016
- Messages
- 123
Hi Guys,
Is there anyway to keep the same value format when looping a range.
Example - cell.value is a date or a percentage, when writing the cell.value to a particular cell it retains the same format.
I know there is a way to do this via copy and paste but there are lots of cell values i need to use in if statements and to write to cells and dont want to copy and paste all the time.
Any help is greatly appreciated.
Thanks
Is there anyway to keep the same value format when looping a range.
Example - cell.value is a date or a percentage, when writing the cell.value to a particular cell it retains the same format.
I know there is a way to do this via copy and paste but there are lots of cell values i need to use in if statements and to write to cells and dont want to copy and paste all the time.
Any help is greatly appreciated.
Thanks