Can anyone tell me a short cut key for 'trace dependents'??
The shortcut key for 'trace precedents' is cntrl + [ for those who
don't know.
Look forward for a shortcut.. :-)
Thanks and regards,
Jaydeep
--~--~-~--~~~---~--~~
---
Hi All,
I want to know, if there is any other option, i.e., other than Track
Changes. I want to know in my excel sheet, if someone does any changes in
any column/Row/Cell for e.g., Adding one row in between of existing rows,
changing the values of cells.
There is a restriction in Track Changes, if
the code below could work.
"ActiveWorkbook.SaveAs "C:\ron.xlsm", fileformat:=52 "
the fileformat value could be changed as follows
*51* = xlOpenXMLWorkbook (without macro's in 2007, xlsx)
*52* = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007, xlsm)
*50* = xlExcel12 (Excel Bina
I got this error : can't find object or library whenever i try to
enter some information into a cell.
can someone advise how to get raid of it?
thanks
--~--~-~--~~~---~--~~
--
Some
I am using DDE to drive MS/Excel 2007 and would like to use SAVE.AS to
save the active workbook as a .xls, i.e. in excel 2003 format.
Has anyone done this and if so can they provide a code sample?
Thanks
Steve
--~--~-~--~~~---~--~~
---
Hi,
I am trying to write a function or a formula which will search from a range
of data and compare with another list and populate the max value
corresponding to it but not able to do so till now.
What i am trying to do is that i will give a name and from a specified table
it will search the where
I finally got this to work, sort of.
For those curious about the code, it calculates least squares
polynomial regression.
To get it to work, I had to do the following
Change B(i) to B(1)
Know that it will continue to do the the do loop. I had to set the end
condition in a subroutine so when it
Thanks for the help Daniel...
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
-Original Message-
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel
S
Hey Daniel
this was fantastic...
thanks for the knowledge
Regards,
Vivek Agrawal
Contact No. +91--154-077
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote:
> Hi,
>
> Select the column, Ctrl+H, what : “~*” (with
Thank You Gents, fantastic as ever..so many ways to Skin A Cat
On Jul 8, 1:27 am, "Ajit Navre" wrote:
> Hi Dave,
>
> Please take a look at the attached workbook- hope this is what you are
> looking for-
>
> (Start from the ThisWorkBook - WorkBookOpen Event Procedure.)
>
> Regards,
>
> Ajit
>
>
>
I can't reproduce it. Can you attach your workbbok to your response ?
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de dom
> Envoyé : mercredi 8 juillet 2009 16:55
> À : MS EXCEL AND VBA MACROS
> Objet : [Norton Anti
Very Good Daniel/Norman...You have got excellent knowledge of Excel..
Keep it up !!
On Jul 8, 8:26 pm, Manoj S Negi
wrote:
> Hi All,
>
> Thanks a lot for you allmy query has been resolved by your nice
> solutions.
> Really very nice tricks I got from you all.
>
> Cheers...
>
> *Unfe
Hi All,
Thanks a lot for you allmy query has been resolved by your nice
solutions.
Really very nice tricks I got from you all.
Cheers...
*Unfeigned Regards
Manoj S Negi
"Miles & miles to go before I sleep"*
On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote:
> Hi,
>
> Select the co
There is no code involved - the form with the RefEdit control is
displayed I have a cancel button that simply unloads the form but the
RefEdit box still has control of Excel. I have got a workaround by
not having the RefEdit be the first control with focus as then when it
gets the focus you are f
This line of code bellow will copy the value of the selected cell to next
cell i.e. value of A1 to B1 retaining the formatting of B1
Selection.Offset(0, 1).Value = Selection.Value
hope this helps
Thanks
Regards,
Vivek Agrawal
Contact No. +91--154-077
Skype ID - vivek.agrawal83
GoogleMoon
you can also try this
select the cells in which you want to apply your formatting...
run this code below
===
Sub ApplyMyFormat()
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor =
Can you post what result you do expect. It is not clear to me how the
parsing have to be made.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Deepak Rawat
Envoyé : mercredi 8 juillet 2009 07:20
À : excel-macros@googlegroups.com
Ob
Can you post your code ?
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de dom
> Envoyé : mercredi 8 juillet 2009 10:48
> À : MS EXCEL AND VBA MACROS
> Objet : [Norton AntiSpam] $$Excel-Macros$$ Curious RefEdit issue
Manoj,
In the find and replace box precede the asterisk with a tilde.
Example: ~*
Norman
On Wed, Jul 8, 2009 at 6:06 AM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi Friends,
>
> Please help meas my query is as follows...
> In the attached sheet in column there is s
Hi,
Select the column, Ctrl+H, what : “~*” (without the quotes), replace all.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Manoj S Negi
Envoyé : mercredi 8 juillet 2009 12:07
À : excel-macros@googlegroups.com
Objet : [Norton AntiS
hi manoj
i am new in useing excel
On 7/8/09, Manoj S Negi wrote:
>
> Hi Friends,
>
> Please help meas my query is as follows...
> In the attached sheet in column there is some data and some cells are
> having * and I want to remove the * from the cells.
> Kindly look into this and
Manoj,
Attached is the file with macro. You just need to select the respective cell
and run the macro.
Thanks
Regards,
Vivek Agrawal
Contact No. +91--154-077
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 8, 2009 at 3:36 PM, Manoj S Negi <
manojsneg
Hi Friends,
Please help meas my query is as follows...
In the attached sheet in column there is some data and some cells are having
* and I want to remove the * from the cells.
Kindly look into this and advice ...
Thanks for your support.
Unfeigned Regards
Manoj S Negi
You can use paste Special-> values in you macro
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those who
don't.
Hi I need to work out if on an average of 20 scores a person scores
3.7 . What would the person need to get on their next sores to acive a
average of 3. the scores that can be acieved are 1 to 5 so basically
how many 3's or 2's or 1's would they need
--~--~-~--~~~---~-
I am building a wizard for some users that uses the Refedit Control.
However if they cancel out of the wizard without entering the control,
somehow the RefEdit control has taken control of Excel and I can only
terminate the Excel process. I am probably doing something obviously
wrong but I can't
Hi. Mahesh,
OFFSET is either an Excel function or a VBA method. I’ll explain the Excel
function first.
It is simplest to give some examples :
=OFFSET(B2,1,0) is equal to : B3 (shifting one row downwards)
=OFFSET(B2,-1,0) is equal to : B1 (shifting one row upwards)
=OFFSET(B2,0,2) is
I am no expert with Outlook. But as I figure it out, it looks like if the
attached file is embedded in RTF. If this is exact, you can't have plain
text format with attached files. You better address an Outlook forum. You
could try the NNTP newsgroup :
microsoft.public.outlook.general
Regards.
Dani
Hi all,
I have been assigned a project wherein I have a worksheet (named "General")
with a list of names (these are the name of worksheet which is there in the
same workbook) and some values which I need to go and paste in the
respective worksheets.
Here what I need to do is search the worksheet wh
Hi
write a code like
Range("b1").Interior.ColorIndex = 0
I hope this help you
Jayavelu
On 7/6/09, tushar patki wrote:
> Dear All,
>
> I have written a code which will copy cell contents from one cell to
> another. Along with the cell contents, also formatting of the cell is
> copied. I am
Hi All,
Please tell me what is the use of OFFSET Command.
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video a
31 matches
Mail list logo
