Types of operators
There are four different types of calculation operators: arithmetic,
comparison, text concatenation, and reference.
Arithmetic operators
To perform basic mathematical operations such as addition, subtraction, or
multiplication; combine numbers; and produce numeric results, use
Hello,
You can use change tracking to log details about workbook changes every time
that you save a workbook. This change history (change history: In a shared
workbook, information that is maintained about changes made in past editing
sessions. The information includes the name of the person who m
I'm not sure I understand what you're asking.
It SOUNDS like you want a list of unique values from column "A"
there's lots of ways to do this.
Let me know if that's what you're looking for,
and what version of Excel you are using.
Paul
From: Meimei
To: MS EXC
Hi all,
I have a question about copy the list of unique values generated by
autofiltering in VBA. For example, if in column A I have cells listing
some animal names, dog, cat, dog, sheep, cat, dog, cat, cat, dog,
sheep. If I do an autofiltering on column A, the autofilter will have
the selection o
Got it working! Here's the final code. I actually have two named
ranges on each worksheet, so the code performs the highlighting for
each.
###
Dim curWks As Worksheet
Dim r As Long
Dim Range1 As Range
Dim Range2 As Range
Set curWks = ActiveSheet
With curWks
If .Name = ("WS1") Then
Set Range
Here is an approach that might work. I'm just not sure of the correct
syntax:
Dim curWks As Worksheet
Dim MyRange as String
Dim r As Long
Set curWks = ActiveSheet
With curWks
If .Name = “WS1” Then MyRange = .WS1Data ' or do you need to say
Set MyRange = .Range(MyRange)
If .Name = “WS2” Th
have you tried recording a macro?
also,
why "multiple sheet at a time"?
I have a loop that looks through 100 sheets
and hides all sheet names that begin with "MTR"
I also unhide all sheets.
It happens almost instantaneous.
(OK, 1-2 seconds)
'---
would something like this work?
Option Explicit
'-
Sub hightlight_all()
Dim I, stat
For I = 1 To Sheets.Count
Sheets(I).Select
stat = Highlight_On_set(Range(Sheets(I).Name &
I don't think the conditional formatting option will work, because the
size of the range changes depending on the data. In other words, there
is no fixed block to select to apply the conditional formula.
On Sep 9, 12:35 am, Dave Bonallack wrote:
> Hi,
>
> I assume your shading is currently done
Thanks Dilip - I've uploaded the file 'sample.xlsx'
Regards, Greg
On 9 Sep, 15:52, Dilip Pandey wrote:
> Hi Greg,
>
> Please share a sample file with the Group. Thanks
>
> Best Regards,
> DILIPandey
>
> On 9/9/10, gdbar...@googlemail.com wrote:
>
>
>
> > Hi
>
> > I'm trying to work out how I
Hi
I want to hide multiple sheet at a time & Unhide multiple sheet at a
time. Please help me with a working macro.
Santanu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi Pankaj,
Can you share a sample data?
Thanks,
DILIPandey
On 9/9/10, Pankaj Kumar wrote:
> Hi, Experts
>
> I need u r help, i have a excelsheet my problem is I am only looking for
> e-mail id in different colums
> ex in Colum F --- resume @alsachi.com
> if I do one by one copy & paste it's a l
Hi Greg,
Please share a sample file with the Group. Thanks
Best Regards,
DILIPandey
On 9/9/10, gdbar...@googlemail.com wrote:
> Hi
>
> I'm trying to work out how I can automate (macro or formula) finding
> specific data in a xls and returning the data in a nearby column.
>
> More sepcifically,
Hi
I need the following tasks to be automated whenever an additional tab
is opened and data pasted into an Excel 2007 worksheet;
1) Look at a specific cell in the added sheet and dependant on its
contents, add an additional row to one of three sections of a summary
sheet (e.g. if cell = "house" t
Hi
I'm trying to work out how I can automate (macro or formula) finding
specific data in a xls and returning the data in a nearby column.
More sepcifically, all the worksheets I'm using include a revenue
total and by this total there is always the text 'ex VAT' (this always
only appears once on a
hi
I have found bits of code from different location on the net. to help
solvinig my issue.
I want to mark rows but only copy and paste some pre slective columns.
but for some reason it doesnt remove the correct columns it look more
like i removes the rows instead.
my code is as following
Su
Dear All,
Please help me or clarify the use following notations
<
>
,,""
::
''""
@
{
}
[
|:
$
#
"",""
Please carify any body when we need to use those notationa while generting
any formula
--
Thanks & Regards
Shivashankar.C.Katageri.
--
--
Thank I had looked at it , it is working fine
On Sep 8, 3:57 pm, r wrote:
> hello Sayyad,
> without the use of vba, try the file
> transpose1.xls
> to link:https://sites.google.com/site/e90e50/scambio-file
>
> regards
> r
>
> On 8 Set, 08:30, Sayyad1284 wrote:
>
>
>
> > Hi ,
>
> > I have a case
Thx ,, This is very helpful & clear solution
On Sep 9, 6:25 am, siti Vi wrote:
> *(1) : Macro VBA-Excel Solution*
>
> Private Sub CommandButton1_Click()
> Dim SrceTbl As Range, DestTbl As Range
> Dim r As Long, nr As Long, c As Integer
> Set SrceTbl = Sheets("Sheet1").Cells(1, 1).Curren
Dear Shivkumar,
Thanks for the honour.
Best Regards,
DILIPandey
On 9/9/10, N.Shivkumar wrote:
> Shri Dilip Pandey has given a very good solution. I generally use the
> following code :
>
> Private Sub Worksheet_Activate()
>
> Sheet1.Protect "1823"
>
> Dim pass As String
>
> pass = InputBox("N S
Hi Kalyan,
To see the code, press Alt + F11 and check the modules and workbook /
worksheets code by right click-> view code option.
Password for sheet is
sheet name is the name u want to restrict. :)
Note: you can change the password later on that sheet itself.
Best Regards,
DILIPandey
On 9/9
-- Forwarded message --
From: Usha Negi
Date: Thu, Sep 9, 2010 at 1:47 PM
Subject: Re: $$Excel-Macros$$ Macro to reshade every other row after column
sort
To: excel-macros@googlegroups.com
Dear All,
Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
and h
Dear Vijayakumar
Thanks for the reply.
My point is that when I enable the track changes option in the Excel
2007 (Review > Track changes > Highlight changes), the editing of text
box is locked by excel.
(I am not sure if I have conveyed the exact point).
Here I am not talking about the worksheet p
Dear All,
Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
and how to use it?
Regards,
Usha
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hello,
In the protect and share work book in the review menu the allow sharing
option was selected .When I deselected the option I was able to make
changes in the text box. I am attecing the cheged sheet for your reference .
Regards,
P.Vijaykumar
On Thu, Sep 9, 2010 at 11:40 AM, Chandru wr
Shri Dilip Pandey has given a very good solution. I generally use the
following code :
Private Sub Worksheet_Activate()
Sheet1.Protect "1823"
Dim pass As String
pass = InputBox("N Shivkumar has for obvious reasons set a Password, kindly
enter password to unprotect sheet")
If pass = "1823" Then
26 matches
Mail list logo
