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
o
can u attach the worksheet
On Sat, Nov 6, 2010 at 12:02 AM, CAN 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
> Date: Nov 3, 10:58 am
> Sub
try this see if it works
Sub Macro1()
ActiveSheet.Columns("a:k").AutoFilter field:=10, Criteria1:="1", _
Operator:=xlAnd
ActiveSheet.Columns("a:k").AutoFilter field:=11, Criteria1:="#N/D!"
End Sub
On Sat, Nov 6, 2010 at 12:22 AM, oryn wrote:
> Hi,
> I have a problem mentioned
On Nov 6, 4:15 am, Paul Schreiner 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 target.column to get
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 fil
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
Date: Nov 3, 10:58 am
Subject: Delete rows from a Sheet based on value found on previous
cell
To: MS EXCEL AND VBA MACROS
I have a
Hi,
The attachment is the solution of your Problem.
What i have sent you it's just a way to gather information and
location of integer value in cell.
And one more thing to Chandra don't mag,up excel formula,Understand them.
After it work Once you understand the formula and how to use it.
Regar
Hi Everyone
i have two workbook , workbook 1 workbook 2. I make macro in workbook 1. now
i want to run macro in workbook2. How i can run macro independly in every
workbook. Is there any solution .
Thanks
--
--
Some
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
Dear ,
Please send me step by step instruction to link pictures with list values .I
have employees record and thier picture ,i want to create a list on emp # now
want when select any emp# from list excell alsow shows related picture also .
--
--
I don't think it's that difficult.
For each named range, the .Row property is the first Row.
.Rowheight is the number of rows in the named range.
.column is the first column
.columnwidth is the number of columns.
So, for Range: "Sheet1Data"
rLast = Range("Sheet1Data").Row + Range("Sheet1Data"
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 interpr
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 t
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 wrote:
> Hi All,
>
> Today i am going to show that how we can separation of integer
> in single cell by
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 that
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 Rang
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 @ http://www.li
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.
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
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
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
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..
22 matches
Mail list logo
