Hi,
Try the below code it will work
---
Sub splitdata()
' Macro Cracked by SJ
Dim rnge As Range, subrnge As Range
Dim strdata(), shtname() As String
Dim i As Integer, r As Integer, s As Integer, ir As Integer
Dim currentshtname As
Hi Osiso
You sent me an email today with another query.
I tried to send back to paraport email but got mail server rejections.
Is there another email I can email you on?
Alvin
On Aug 6, 3:05 am, osiso fahe...@gmail.com wrote:
i would like to add an example of what im trying to do. please
Hi Jack,
The Active-x textbook doesn't have a limit other than the resources
available on that machine.
You could set the TextBox.maxlength = 0 which is the default for any
number of characters.
Hope this helps
Andre
On Aug 6, 10:19 am, Jack j...@jackcwood.co.uk wrote:
I have a text box on a
Hi Harris,
One could also write the formula to be;
=if(isna(A1),0,A1)
A1 is the reference of your Formula, so it could be anything from a
sum to a lookup and so on.
Thanks
Andre
On Aug 6, 8:31 am, harris a harris...@gmail.com wrote:
Hello,
In case a formula is returning “#N/A” then is
Hi
URGENT HELP
I want to calculate the sum of only postive numbers in a row of both postive
and negative numbers. excel sheet is attached
PLS TREAT THIS AS URGENT
regds
anil nair
--~--~-~--~~~---~--~~
excel sheet is attached
-- Forwarded message --
From: ANIL NAIR anil.nair1...@gmail.com
Date: 7 Aug 2009 14:09
Subject: urgent - How to calculate sum of only positive numbers
To: excel-macros@googlegroups.com
Hi
URGENT HELP
I want to calculate the sum of only postive numbers in
Hi Anil,
Solved sheet is attached with this email. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Aug 7, 2009 at 2:10 PM, ANIL NAIR anil.nair1...@gmail.com wrote:
excel sheet is attached
Hi,
U can try this
=SUMIF(E4:E8,0,E4:E8)
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ANIL NAIR
Sent: 07 August 2009 PM 02:09
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent - How to calculate
Sirjee
One additional help required on ur solved work sheet regarding the problem
by Anilji. Noticed what i feel is strange behaviour.
I use Excel2007. Your formula with {=SUM(IF(E4:E80,E4:E8,))} work fine
but the moment i click to edit on the cell where this formula is entered,
the {}
Or simply use the SUMIF function as in the attached doc.
On 8/7/09, Dilip Pandey dilipan...@gmail.com wrote:
Hi Anil,
Solved sheet is attached with this email. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
U can do control+shift+enter instead of normal enter
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: 07 August 2009 PM 02:46
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: urgent - How
Hi All,
I would be grateful if you could help me out with the following problem I am
facing with regard to data formatting:
The changes I need to make to the file are as follows:
1. I need to deduct one hour from the 'CaptureTime' field(column E) which is in
seconds.
This I
Hi All,
Apologies for sending this request. I seem to have found out the solution. I
wasted one whole hour trying to figure out something which was simple, but I
seem to have over looked how the formatting is done. Please do not waste your
time on this request.
Apologies once again.
Hi Vivek,
Send me the macro as text file as my outlook had blocked Potential unsafe
attachment .bas please.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
Hi osiso,
You need to nest match function inside your vlookup.
Send me the excel file with sample data and I'll show you how
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi
Attached is the Text File
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Fri, Aug 7, 2009 at 5:34 PM, Upendra Singh
upendrasinghsen...@gmail.comwrote:
Hi Vivek,
Send me the macro as text file as my outlook had
Hi Dilip !
I have checked sheet , formula is perfect( sum and If
combination) but it doesn't work for other columns ...please explane...
Many thanks !
On Fri, Aug 7, 2009 at 3:09 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Anil,
Solved sheet is attached with this
Attached is the solution
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ANIL NAIR
Sent: Friday, August 07, 2009 2:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent - How to calculate sum of only positive
numbers
excel
I am running Excel 2003. When I sign a document with a digital
signature, is there any way to easily see that the document is signed
without having to go to Options - Security - Digital Signatures? In
Word there is a red ribbon that's displayed at the bottom of the
screen. Also, is there a way
Hi Shafiq,
This is the awesome tip. Appreciate your knowledge. :)
regards,
Ayush Jain
On Aug 7, 3:48 pm, shafiq online shafiq_onl...@hotmail.com wrote:
Dear All,
Here is a tip for pop up calendar in Excel. You can display a clander in a
excel sheet and enter date in a cell by slecting the
Hi,
Attached workbook with solution. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Aug 6, 2009 at 6:23 PM, Putta Madaiah puttamada...@gmail.comwrote:
Hi All,
Can anyone provide me the
My VBA Code is trying to Find the string 'STABLE' and Replace it with
the string 'STA', searching a VBA-selected variable range.
Code snippet follows:
Range(E5:X (iTotalRecs * 2 + 4)).Select
Selection.Replace What:=STABLE, Replacement:=STA, LookAt:=xlWhole,
_
SearchOrder:=xlByColumns,
=IF(B45,IF(E42,IF(H42,Yes,No), No), NO)
On Aug 6, 5:53 pm, Putta Madaiah puttamada...@gmail.com wrote:
Hi All,
Can anyone provide me the formulas as per the requirement in the attachment.
Rgds,
Putta - Bangalore
Formula.xlsx
35KViewDownload
I have a worksheet that uses a VBA macro to determine a result for several
cells based on a use drop-down list. When I use a regular formula (not a Macro)
to calculate something, it always refreshes when the user changes the choice in
the drop down.
However, when I use a VBA Macro, Excel seems
24 matches
Mail list logo
