how to covert formula cell in general

[manoj_arsul]

Hi

I need Program for convert formula into general value But for other sheet .

I having the below program but its working only for same sheet . But i want run the below program for Sheet2 from Sheet1

Sub Convert_To_General()
Dim vData As Variant

vData = Columns(9)

Columns(9).NumberFormat = "General"
Columns(9) = vData

End Sub

 

[nemmi69]

Sub Convert_To_General()
Dim vData As Variant


vData = Worksheets("Sheet2").Columns(9)


Worksheets("Sheet2").Columns(9).NumberFormat = "General"
Worksheets("Sheet2").Columns(9) = vData


End Sub

 

[manoj_arsul]

Hi @nemmi69
Thank u So much