![]() |
runtime error 1004
recibo este error cunado ejecuto este script en excel version espa=F1ol
mas no cuando lo ejecuto en version ingles, me dicen que es por la denominacion de las celdas en espa=F1ol que es para linea L y en ingles es R a continuacion adjunto el script, agradezco quien me pueda ayudar a resolver esto gracias Public Function gf_CopyPasteData(s_range As String, s_range2 As String, i_start_sheet_index As Integer, i_end_sheet_index As Integer) As Integer 'copies data from sheet one sheet to another sheet If CInt(Range(s_range).Count) =3D CInt(Range(s_range2).Count) Then Sheets(i_start_sheet_index).Range(s_range).Copy _ Destination:=3DSheets(i_end_sheet_index).Range(s_r ange2) 'validation passed, both ranges are of the same size gf_CopyPasteData =3D 0 Else 'validation failed, both ranges are a different size gf_CopyPasteData =3D 1 End If =20 End Function |
All times are GMT +1. The time now is 09:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com