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: 7
Default Syntax or Something is KILLING Me

Folks, call me stupid, call me an occassional VB player but I cannot figure
out what is happening.

If I execute this statement:

Sheets("Estimator").Range("E14").NumberFormatLocal = CurrFormat

It works just fine. However, if I make things slightly more complex such as:

Const WorkColEntry = "E"
ComboRow = Str(ComboBox1.ListIndex) ' happens to be 14

Sheets("Estimator").Range(WorkColEntry + ComboRow).NumberFormatLocal =
CurrFormat

This statement blows up with an error:

Run-time error 104, Application-defined or object-defined error,

A very abstruse error definition I might add. In debug of the statement in
question, WorkColEntry is "E" and ComboRow is "14".

So what gives? It is 10:45 PM here in Singapore. To heck with this. Time
for sleep and a game of golf tomorrow.


 
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
Before_Save IS KILLING ME Paige Excel Programming 11 March 7th 07 12:55 AM
killing accents sos Philippe Excel Programming 2 December 23rd 05 08:06 AM
VBA loop is killing me! Dave Bailey Excel Discussion (Misc queries) 1 October 14th 05 07:43 AM
help me out with this - it's killing me.. popovsky[_8_] Excel Programming 6 July 22nd 05 09:20 AM
killing a sub from within an if statement Cliff L Excel Programming 8 May 11th 05 02:04 PM


All times are GMT +1. The time now is 01:55 AM.

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"