LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Slow coding in VBA Excel 2003

I am running a routine in Excel 2003 which takes minutes
to execute. The same routine in Excel-97 is exceuted
instandly showing no measurable delay.

The routine:

Set q1 = Workbooks(wbi).Sheets(wsi).Range(s1)
Set q3 = Workbooks(wbi).Sheets(wsi).Range(q1, q1.End
xlDown))
q3.Offset(0, 10).Select
For Each cell In Selection
cell.Value = cell.Value * 1
Next cell

The input file is a flat text file with 1000 records (rows)
I want to be sure that the data in collumn 10 is numeric
when copied. Previously in the coding I replaced some
decimal points for decimal comma's. This is the reason to
multply by 1.

It is the for/next loop (1000 cells) which takes 2
minutes on a 2,6 Ghz system.

regards,
Erik
 
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
Coding issue with Excel 2003 Neil Holden Excel Discussion (Misc queries) 1 February 18th 10 04:38 PM
Excel 2003 VB CODING Neil Holden Excel Discussion (Misc queries) 2 February 17th 10 11:15 AM
Excel 2003 coding issue Neil Holden Excel Discussion (Misc queries) 0 February 16th 10 09:18 AM
Excel 2003 very slow uyyy Setting up and Configuration of Excel 2 January 9th 08 09:16 AM
Excel 2003 Gets Slow moba00 Excel Discussion (Misc queries) 0 April 15th 05 02:11 PM


All times are GMT +1. The time now is 05:09 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"