To all the members families
Happy Deewali
Kishan Reddy, K
On Nov 4, 8:54 pm, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi Ashish,
WISH U THE SAME
Thanks
Chandra Shekar B
On Thu, Nov 4, 2010 at 6:08 PM, ashish koul koul.ash...@gmail.com wrote:
Wishing you all A Very Happy
-- Forwarded message --
From: vebhav jain vebhav.j...@gmail.com
Date: Thu, Nov 4, 2010 at 2:01 PM
Subject: $$Excel-Macros$$ Data Keep Varies
To: excel-macros@googlegroups.com
Hi All,
With the help of macros, i recorded the whole data. The problem is that data
keep varying every
can u attach excel sheet..
On Fri, Nov 5, 2010 at 11:40 AM, vebhav jain vebhav.j...@gmail.com wrote:
-- Forwarded message --
From: vebhav jain vebhav.j...@gmail.com
Date: Thu, Nov 4, 2010 at 2:01 PM
Subject: $$Excel-Macros$$ Data Keep Varies
To:
Can any body explain what technique behind this beautiful drawings sheet .
Date: Thu, 4 Nov 2010 20:05:16 +0530
Subject: $$Excel-Macros$$ Fwd: Village
From: rajasekhar.prahar...@gmail.com
To: excel-macros@googlegroups.com
Hi friends,
Happy Diwali to one and all..
From: عمر [mailto:omar27...@gmail.com]
Sent: Monday, November 01, 2010 7:31 PM
To: MS EXCEL AND VBA MACROS
Subject: is there a printer installed on this computer?
I have a code to copy some data from sheet to another
In the end of this code
There is some lines to set up
try this code it will help you in checking whether printer is installed or
not and accordingly you can make changes in ur code
Sub a()
On Error Resume Next
Application.ActivePrinter = x
If x = Then
MsgBox Printer Not Installed
Else
MsgBox x
End If
End Sub
On Fri, Nov 5, 2010 at 1:18
Very thanks
I tested this code on computer which has printer installed but this printer's
power is off
Is ActivePrinter means installed but not plug in ?
That is exactly what I want
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of ashish koul
My dataset occupies 50 rows by 20 columns which I defined as my
database.
There is no difficulty if I choose to sort the database either by a
known column or row.
But what I really want the program to do is to sort it by column
wherever the active cell
happens to be - whose location is unknown.
I have several dynamic named ranges that span multiple worksheets. The
ranges are named Sheet1Data, Sheet2Data ... up to Sheet4Data.
I need to create a macro that applies a bottom border to the last row
in each range. I've taken some code that loops through the *cells* in
each range (Dim c As
I found that
application.MacroOptions
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hey there.
This problem is giving me a major headache and no post I have read can
seem to help with the problem I am having.
I have some code to copy any present data from CSV files to a main
workbook (basebook) but some seem to paste over as mm/dd/yy instead of
dd/mm/yy...
Two of the CSV's
Hi,
Nice formula but its not working with this data a 958 b 951 will return same
value is there any way to do this.
Thanks
Chandra Shekar
On Wed, Nov 3, 2010 at 7:48 PM, Vishal Parihar vish.pari...@gmail.comwrote:
Hi All,
Today i am going to show that how we can separation of integer
So you're saying that if you select a cell,
the data will be re-sorted with the column of the active cell
being the primary (or only?) sort field?
should be simple enough using a selection_change event.
use target.column to get the column number for the sort.
you would also want to check to see
Keep in mind that Excel isn't storing a date.
If it finds a string that it INTERPRETS as a date, then it calculates the number
of days between 1/1/1900 and this date and stores the number.
Excel can then DISPLAY the number as a date.
If the string isn't in a proper date format, then Excel
Hi Everyone,
Wish you happy Diwali to all my sir, and friends .
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
I posted this discussion a few days ago and I haven't hear any answers
on it. Does anyone can help ?
Thank you
-- Forwarded message --
From: CAN cdelano...@gmail.com
Date: Nov 3, 10:58 am
Subject: Delete rows from a Sheet based on value found on previous
cell
To: MS EXCEL AND
Hi,
I have a problem mentioned in topic.
I have macro like this:
Sub Przycisk22_Kliknięcie()
Range(A:K).AutoFilter field:=11, Criteria1:=1,
Operator:=xlFilterValues
Range(A:K).AutoFilter field:=12, Criteria2:=#N/D!,
Operator:=xlFilterValues
End Sub
The result is that filters
On Nov 6, 4:15 am, Paul Schreiner schreiner_p...@att.net wrote:
So you're saying that if you select a cell,
the data will be re-sorted with the column of the active cell
being the primary (or only?) sort field?
That is correct.
should be simple enough using a selection_change event.
use
can u attach the worksheet
On Sat, Nov 6, 2010 at 12:02 AM, CAN cdelano...@gmail.com wrote:
I posted this discussion a few days ago and I haven't hear any answers
on it. Does anyone can help ?
Thank you
-- Forwarded message --
From: CAN
Hi,
If you are using Excel 2007 ,then go to the Ribbon button ,Then Click the
Excel Options button .You will get a box with all the settings.In that
select Trust Center Settings. again a new box will appear with Settings for
Active X control and Macro settings etc.Select macro settings..In the
20 matches
Mail list logo