Copying data special values to dataform using VBA in smartview
Summary
Copying data special values to dataform using VBA in smartviewContent
Hello,
We have requirement where when a user enters datain excel sheet it needs to under go some calculations and this data should then be loaded to data form through smart view(As SOX control in process we can only load data through data form or FDM).So I created macro enabled sheet and integrated the data form with it.I am using below code to copy the calculated data from excel sheets and paste special values to smartview form(data form) but somehow the formula is being copied into data form for certain cells(This is starting at cells F15 in data form).when I run
0