Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Strange variable declarations

Hi All,

I have come across the following variable declarations in
a program i have inherited. I was wondering what the $
sign is there for.

Dim Row$
Dim EVT$
Dim Paste$
Dim Results$

Values can be assigned as normal and my first though is
that it changes the values to text strings automatically.
I just though i'd ask and see if this was the case.

Cheers,
Steven
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Strange variable declarations

It is known as "type-declaration character" and is same as
declaring the variable with the following types:
$ String
@ Currency
# Double
% Integer
& Long
! Single


Francisco Mariscal


-----Original Message-----
Hi All,

I have come across the following variable declarations in
a program i have inherited. I was wondering what the $
sign is there for.

Dim Row$
Dim EVT$
Dim Paste$
Dim Results$

Values can be assigned as normal and my first though is
that it changes the values to text strings automatically.
I just though i'd ask and see if this was the case.

Cheers,
Steven
.

Reply
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 '91' Object variable or With block variable not set Alec Coliver Excel Discussion (Misc queries) 2 October 24th 09 02:29 PM
can i link a variable cost code with a variable sum I need help!! Excel Discussion (Misc queries) 0 August 1st 08 11:40 AM
variable height variable width stacked bar charts ambthiru Charts and Charting in Excel 3 January 18th 06 11:41 PM
Sum cells based on a row variable and seperate column variable CheeseHeadTransplant Excel Worksheet Functions 10 September 23rd 05 06:59 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM


All times are GMT +1. The time now is 11:26 AM.

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

About Us

"It's about Microsoft Excel"