ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   runtime error 1004 (https://www.excelbanter.com/excel-discussion-misc-queries/50008-runtime-error-1004-a.html)

valdesd

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