Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
runtime error '6' overflow | Setting up and Configuration of Excel | |||
Runtime Error '1004' | Excel Discussion (Misc queries) | |||
runtime error '800a9c64' | Excel Discussion (Misc queries) | |||
Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
Why do I get the runtime error message430 when I start my compute. | Setting up and Configuration of Excel |