Dabo
06-02-2009, 06:40 AM
Hi all,
I am struggling with this one :
In order to use a filter, I need to fill a cell with the value of another cell set at the right format
Ex:
Cell 1 = test
Cell 2 = ="=Test"
My code is roughly
cell2.value = "=" & """=" & cell1.value & """"
everything is okay, except when there are quotes within Cell1
Ex:
Cell 1 = test " test " test
=> Bug
How to cope with that ?
I am struggling with this one :
In order to use a filter, I need to fill a cell with the value of another cell set at the right format
Ex:
Cell 1 = test
Cell 2 = ="=Test"
My code is roughly
cell2.value = "=" & """=" & cell1.value & """"
everything is okay, except when there are quotes within Cell1
Ex:
Cell 1 = test " test " test
=> Bug
How to cope with that ?