Groups > microsoft.public.excel.programming > #109974

Re: Formatting multiple sheets within workbook.

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Formatting multiple sheets within workbook.
Date	2017-03-31 07:13 -0400
Organization	A noiseless patient Spider
Message-ID	<obldf0$aa1$1@dont-email.me> (permalink)
References	(4 earlier) <obh9qb$l7e$1@dont-email.me> <f722d396-80cf-438a-8eb5-bbde006c810b@googlegroups.com> <obinl1$85j$1@dont-email.me> <obj70c$sfk$1@dont-email.me> <44e2cb22-8088-4f58-9a96-e64bfaae72fe@googlegroups.com>

Show all headers | View raw

> Hi Garry
>
> I understand your concerns with declaring, and if I was churning out this 
> stuff for a livelihood I would probably pay more attention to it, but!
>
> In that this is a side thing I actually don't get paid to do for my cheap-ass 
> employer who at times gives me 5 minutes to do the impossible, I skrimp and 
> scrape and use the melting-pot to butcher out this stuff on time.
>
> Mostly it's for my own usage and short-term it will be from here-on as the 
> company are currently spending millions on an entirely purpose designed and 
> built system called Ramco to handle every conceivable corner of business 
> activity so most of what I have done will go out with the trash.
>
> One day I might even retire and go back to school and actually learn what it 
> is I do with VB Excel and Access. But that's not likely to happen for a 
> while.
>
> Cheers
> Mark.

It would just be doing yourself a favor to require variable declaration because 
your VBE will let you know when things won't compile. Also, it saves having to 
remember variable names because intellisense will display them after typing a 
few letters and pressing Ctrl+J! You only have to check the box once and the 
VBE automatically sets that up for you thereafter!

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Thread

Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-28 03:40 -0700
  Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-28 03:42 -0700
  Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-28 10:56 -0400
    Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-29 03:40 -0700
      Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-29 11:48 -0400
        Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-29 17:46 -0400
          Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-30 03:25 -0700
            Re: Formatting multiple sheets within workbook. Claus Busch <claus_busch@t-online.de> - 2017-03-30 12:48 +0200
              Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-30 06:16 -0700
                Re: Formatting multiple sheets within workbook. Claus Busch <claus_busch@t-online.de> - 2017-03-30 15:48 +0200
              Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-30 11:10 -0400
                Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-31 04:03 -0700
                Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-31 07:13 -0400
              Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-31 03:51 -0700
                Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-31 07:08 -0400
    Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-29 03:52 -0700
  Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-29 02:43 -0700
  Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-04-03 04:12 -0700

csiph-web