Hi everyone,
First time posting to this group. Glad to have found it. I have a
question regarding capturing cell data into an array in VBA. If I use
the following code:
tmp() = Range("A1:A20")
I can capture the values of these cells into my array. This seems to
produce a double as the data type,
just multiply by 24
time 3:48 in cell A1
=A1*24
resulting: 3.80
that is equal to:3 + 48/60
not 4.48
CMIIW
On Fri, Oct 15, 2010 at 10:55 AM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:
> Hi Friends,
> Please let me know that how can I write time in decimal format.
> Time :
*code is Thisworkbook in VBAproject *
On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah wrote:
> Thanks Vishal
>
> Its working
>
> Can u explain how u done this (If its posible)
>
> Once Again Thanks
>
> Dharmesh Shah
>
>
>
>
>
> On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
>
>> NOW OPEN FI
On Fri, Oct 15, 2010 at 9:25 AM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:
> Hi Friends,
>
> Please let me know that how can I write time in decimal format.
>
> Time :- 3:48 (3 hours 48 mins) then it should show 3.48
>
> Thanks in advance
>
> Regards,
> Vijay
>
> --
>
> ---
Dear
Use sumif formulas
SUMIF(Sheet1!$A$2:$A$19,Sheet2!A2,Sheet1!$B$2:$B$19)
CR-MSP-619+ 110 CR-MSP-620 600 CR-MSP-621 400 CR-MSP-622 180
CR-MSP-623 140 CR-MSP-624+ 110 CR-MSP-625 150 CR-MSP-626 350 CR-MSP-627+
80 CR-MSP-628 360 CR-MSP-629 1000 CR-MSP-630 80 CR-MSP-631+ 140
CR-MSP-63
Hi Friends,
Please let me know that how can I write time in decimal format.
Time :- 3:48 (3 hours 48 mins) then it should show 3.48
Thanks in advance
Regards,
Vijay
--
--
Some important links for excel users:
1. F
Given a Range object (e.g: set xRange = Range("C1:D10") )
And given xRow = 5 , which stands for Row 5 (absolute Row index)
How to define a range "yRange" based on "xRange" so that yRange is
Range("C5:D10") ?
thanks
--
-
DynPro specializes in helping companies build infrastructures that can
weather the most fierce storms by focusing on strong fundamentals:
appropriate and effective systems, the right people, and proven business
processes. Our worldwide force of technology and business experts can
identify the right
hi
check the attachment see if it helps you
you can apply customer filter on temp column and choose greater than 1 and
copy all and paste into sheet2
On Thu, Oct 14, 2010 at 8:06 PM, renuka chari wrote:
> GOOD EVENIG ALL EXPERTS
> CAN U SLOVE MY VLOOKUP PROBLEM
>
> THIS IS MY DATA IN SHEET1
>
GOOD EVENIG ALL EXPERTS
CAN U SLOVE MY VLOOKUP PROBLEM
THIS IS MY DATA IN SHEET1
=
VNo CR Amt
=
CR-MSP-619+ 70
CR-MSP-620 600
CR-MSP-621 400
CR-MSP-622 180
CR-MSP-623 140
CR-MSP-624+ 60
CR-MSP-625 150
CR-MSP-626
*Hi Noorain,
you may also use True false formula and count if for this.
*
On Thu, Oct 14, 2010 at 3:04 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Pls find the attachment
>
>
>
>
> On Thu, Oct 14, 2010 at 1:10 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Srinivasan,
>>
>>
Mr. Naveen
Please explain to Mr. Shrinivas.
i am request please provide vba code.
Regards
Sumit
On Thu, Oct 14, 2010 at 5:17 PM, shrinivas shevde
wrote:
> Please Can I know how to do it?
>
> shrinivas
>
>
>
> --
> Date: Thu, 14 Oct 2010 13:16:47 +0530
> Subject:
Do you mean to change the file associations?
For that, what you do is change your own associations.
Then go to the system registry (using run -Regedit)
Find your .xlsx extensions, right-click and "export" the settings
to a file (it'll put a .reg extension)
You should get something like:
[HKEY_LOC
There's a couple of things that can be done.
But it depends on what "control" you have over the other worksheet.
Can you "name" the range on the other worksheet?
For example, in the Budget_Estimation_Tys.xls file, Sheet1, name
cell B2 "Groceries"
Then, cell ## "Insurance" (or whatever)
Then in
Dear Vijay,
How to Embed Flash Game in Excel Spreadsheet
Intructions
Things You'll Need:
- Microsoft Excel(this how-to is based on the 2007 version)
- A downloaded flash game
- internet connection
1. Download free flash game online or use one you already have
2. Open Excel and
Please Can I know how to do it?
shrinivas
Date: Thu, 14 Oct 2010 13:16:47 +0530
Subject: Re: $$Excel-Macros$$ Text to collumn
From: nsharma110...@gmail.com
To: excel-macros@googlegroups.com
It is resolved. Please have a look
Naveen
98219 80081
On Wed, Oct 13, 2010 at 11:59 AM, Kashan
Hi MVP/Gurus,
I am trying to use Icon Sets (RYG) conditional formatting tool for the
attached spreadsheet in excel 2007. Now I have used this before but this
time the indicator icons are not in line with the specified conditions
(default).
Case in point
- 6% should be red its green
- 63% should b
I am creating workbooks that routinely contain misspelled (or
alternately spelled...) words. I would like to be able to automate a
search for a variety of words, and replace them with the correct word.
For example, one that I commonly see is "MLK" which I would need to
replace with "Martin Luther
I routinely create large lists of address and then have to map them.
I get addresses that are clearly invalid (1 homeless dr, 0 unknown st,
etc). These really mess up the mapping program (batchgeo.com). I
would like to be able to search my workbook for any cell in the first
column that contains a
Pls find the attachment
On Thu, Oct 14, 2010 at 1:10 PM, NOORAIN ANSARI wrote:
> Dear Srinivasan,
>
> Below formula is not working properly. We are unable to find valid output.
>
> Please suggest...
>
> Thanks,
> Noorain Ansari
>
> On Wed, Oct 13, 2010 at 10:33 AM, Srinivasan Ethirajalu <
> sr
Dear Srinivasan,
Below formula is not working properly. We are unable to find valid output.
Please suggest...
Thanks,
Noorain Ansari
On Wed, Oct 13, 2010 at 10:33 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Paste the below formula in D2
>
> =IF(COUNTIF(A$2:A2,A2)=1,"U
In case you don't need historical data you can use this.. replacing
date should work fine in most cases...
On Oct 14, 11:04 am, Dilip Pandey wrote:
> Oh. . . . . that's awsome :)
>
> It is a good approach if u dont want to keep the history (previous month).
>
> Best Regards,
> DILIPandey
>
> On
22 matches
Mail list logo
