Reddy Yarasi
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 9:14:09 PM
Subject: Re: $$Excel-Macros$$ Passing Variable to another function
Hi Manhar,
Use the following formula,
=LEFT(C3,FIND("'",C3,1)-1)+VALUE(MID(C3,FIND("'",C3,1)+1,FIND("&quo
From: hanumant shinde
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 12:48:05 AM
Subject: Re: $$Excel-Macros$$ Passing Variable to another function
Hi Paul,
Sorry for late reply as i was out of town i couldnt check this out.
Thanks a lot paul for your det
Hi Manhar,
Use the following formula,
=LEFT(C3,FIND("'",C3,1)-1)+VALUE(MID(C3,FIND("'",C3,1)+1,FIND(,C3,1)-FIND("'",C3,1)-1))/12
Above formula is for the value entered in Inches in cell C3 and always the
value is expected in Feet(') and Inches("), the forumula also ignores the
multiple spaces
_
From: hanumant shinde
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 12:48:05 AM
Subject: Re: $$Excel-Macros$$ Passing Variable to another function
Hi Paul,
Sorry for late reply as i was out of town i couldnt check this out.
Thanks a lot paul for your detail explan
Dear All
I require your urgent help for attach file.
Please find attach file for calculation of Square meter form Inches to
Centimeter.
I want to a formula which convert inches in to Centimeter.
Example
10' 3'' is equal to 10.25 for Calculation of Square Feet.
Thanks and regards
Manhar Prajap
______
From: Paul Schreiner
To: excel-macros@googlegroups.com
Sent: Mon, 7 February, 2011 11:41:24 PM
Subject: Re: $$Excel-Macros$$ Passing Variable to another function
Your question is a bit confusing:
You want to know "if we can pass the variables without initializing the
= " & TestVar
End Sub
Function TestFunction(TestVar2)
TestVar2 = TestVar2 + 1
MsgBox "Function:" & Chr(13) & "TestVar = " & TestVar & Chr(13) & "TestVar2
= " & TestVar2
End Function
does ANY of this answer your actual quest
Hi friends,
I wanna know if we can pass the variables without initializing them to any
other
function and get their values from that called function please find the below
example. which is similar to that of i have seen.
dim workingday as some data type
Sub calling ()
if not (calculateworkingd
