check this
Sub checkforformula()
Dim i As Long
Dim cell As Range
For Each cell In Cells.SpecialCells(xlCellTypeFormulas)
MsgBox cell.Address
Next cell
End Sub
Sub ab()
Dim i As Long
Dim cell As Range
'ActiveSheet.UsedRange.Select
Cells.Select
For Each cell In Selection
If Len(cell.Tex
Hi Group,
I have a weird query today, i hope i am able to present the case and a
solution is possible for it.
I need to achieve the following:
1) A macro that will search the whole sheet for those cells which consists
of formulas
2) And if a cell is found meeting criteria one, It needs to be ab
Hi Vinu,
I looked at the link provided by you.
I have attached a workbook with this email, i hope this resolves your
problem. I have used the following code:
Private Sub Workbook_Open()
'Advise the user the workbook will close if inactive for 10 seconds.
'To adjust the time, such as if you want
Dear Friends,
is there a way with which i can convert my excel file to interact with my
trading software
and make decisions and trade on that automatically.
Regards,
Nitin Gupta
IBS Bangalore
9731423808
--
--
Some
For the data range you have specified, following is the solution:
A B C (formula)
25 0 -1002->= countif(a1:a7,">0") -
countif(a1:a7,">100")
150101 -200 1 -->= countif(a1:a7,">100") -
countif(a1:a7,">20
Dear pratap, it is ok for mis analyst.
SAS is statistical analysis tool n should be learnt if ur mis profile
includes working on models or engineering domains.
But yes learning of SAS will b a + point. :)
thx,
DiLipandey
On 4/21/10, pratap wrote:
> Good evening All,
>
> I want to be an MIS analy
Dear friends,
I want a macro for hide and unhide the sub headings in excel, like we
can do in MS project with +mark, when we click on + symbol it
highlights the subtask available in that particular task.
Is it possible??., pleas help me
--
I am looking for ebook of the below .If any one has do let me knw...
Professional Excel Development: The Definitive Guide to Developing ...
By Rob Bovey, Stephen Bullen, Dennis Wallentin, John Green
--
--
Some impor
Hi All,
Can anyone explain What is SAS Programming!
Regards,
Rajesh.Nair
On Wed, Apr 21, 2010 at 6:21 PM, pratap wrote:
> Good evening All,
>
> I want to be an MIS analyst do i need to learn SAS programming.
> or will it be ok to learn advance excel, vba and macros.
> Please suggest.
>
Hello
Here is your solution.
Chandra Gupta
On Sat, Apr 24, 2010 at 3:03 AM, vinu wrote:
> Hello Frnds,
>
> I have a data like this: columnA -Data & column B- range & column c-
> Data in Range(Need formula for this), Please help me a formula to get
> the answer in column C.
>
> A
10 matches
Mail list logo
