Goodmorning
am working on a Project on VB6. THis is an excel automation... the VB6 Program reads from the Excel File and transfer the search data if found to another excel file... Its working properly...
MY QUESTION is how to copy if cell is only generated by a formula?
Example.
IF i label a sheet by the use of formula it cannot read/display by the program...
This is my code in the vb6 program:
Expand|Select|Wrap|Line Numbers
- wksht.Range("A" & (Counter - 4)).EntireRow.Copy
- xlBook2.ActiveSheet.Paste Destination:=xlBook2.Worksheets("summary").Range("A" & RowCntr)
xlBook2-has only 1 sheet and this is where the search data if found is paste.
The only problem is it cannot copy the Label which is generated by a formula.
Am copyng the entire row and paste it to another excel but the formula generated Text cannot be displayed only its formula...
any help is accepted big/small...
Thanx to all....