Does anyone have idea how to solve this problem. I would like to paste selected cells(with value) and not overriding the formula. After i would hit refresh the value would be written in database.
Thx a lot in advance,
I use the SETDATAIF formula for this.
E.g. The Palo.Data formula is in column B than you can replace the formula palo.data(SERVER,....) with PALO.SETDATAIF(CONDITION,VALUE,SPLASHING,SERVER,...) and I copy the new values in Column C for example. in cell C1 where is a value to be set, if the data should be written to PALO. So condition could be C1=1. If you write 1 to C1 the data will be written to PALO
See my topic "All about VBA and PALO" in Best Practices