LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 536
Default Error with calling Format sub

On Thursday, June 27, 2013 1:37:48 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 27 Jun 2013 01:10:54 -0700 (PDT) schrieb Howard:



https://www.dropbox.com/s/eldkj3rjds...rop%20Box.xlsm




your range "CrypyoLine" is not filled completely. So if you run through

each c of this range you have empty cells at least.

Please look he

https://skydrive.live.com/#cid=9378A...121822A3%21326

for the workbook "Crypto Boogie"

Now there is a IF-Statement

If c <""

You could also make the range "CrypyoLine" dynamic and work without that

IF-Statement.





Regards

Claus Busch


Well, that certainly cleaned things up nicely.

I'm mighty grateful.

Thanks.

Regards,
Howard
 
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
format calling cell RedLars Excel Programming 3 March 24th 08 02:30 PM
calling calendar, get Automation Error Arnold Klapheck Excel Programming 1 November 22nd 06 02:47 AM
calling a subroutine to format date(s) jenelle Excel Programming 7 February 6th 05 09:35 PM
Error 49: Bad .dll Calling Convention Jarrett Sadowsky Excel Programming 1 January 20th 04 07:52 PM
Bad DLL Calling Convention (Error 49) Shaikh Excel Programming 3 November 18th 03 10:18 PM


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