LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
valdesd
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
runtime error '6' overflow don Setting up and Configuration of Excel 1 July 26th 05 02:52 AM
Runtime Error '1004' [email protected] Excel Discussion (Misc queries) 2 July 18th 05 06:10 AM
runtime error '800a9c64' Dimple Wathen Excel Discussion (Misc queries) 0 July 14th 05 07:29 PM
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Why do I get the runtime error message430 when I start my compute. Thorcat Setting up and Configuration of Excel 1 December 2nd 04 07:15 PM


All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"