I am using open office not MS office could it be an issue
On Thursday, March 7, 2013 11:17:46 AM UTC+5:30, anubha gupta wrote:
>
> Hi this is same which you have sent
>
> I have attached again
>
> On Thursday, March 7, 2013 9:51:25 AM UTC+5:30, अनिल नारायण गवली wrote:
>>
>> Dear Anu,
>>
Hi group,DO ant one have a telephone directory template where i can save my
personal and bussiness phone nos. with some other data like e.mail, DOB,
Address etc
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi
Dear Anu,
Pl share that sheet in which u r getting nothing.
Warm Regards,
Gawli Anil
On Wed, Mar 6, 2013 at 5:11 PM, wrote:
>
> Thanks Anil for that much help
> But still when I run your defined macro 'Sheet3' it change nothing.
> I also try to call that function using '=Sheet3()' but not work
Hi Azhar,
Try this
Sub way()
Dim r As Range
Dim nLastRow As Long
Dim nLastColumn As Integer
Dim i As Integer
Dim HideIt As Boolean
Dim j As Long
Set r = ActiveSheet.UsedRange
nLastRow = r.Rows.Count + r.Row - 1
nLastColumn = r.Columns.Count + r.Column - 1
For i = 1 To nLastColumn
HideIt = True
Thanks Ashish
.
Enjoy
Team XLS
On Wed, Mar 6, 2013 at 9:37 PM, ashish koul wrote:
> Hi xls
>
> visit this
>
>
> http://forums.codeguru.com/showthread.php?301647-Permutations-Combinations-Problem-in-VBA
>
> Regards
> Ashish
>
>
> On Wed, Mar 6, 2013 at 6:57 PM, Prince
Hi Manjunath,
We can not disable the save option of any excel file without using VBA, But
in case of VBA Just Write the below metioned Code
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub
Regards
Prince
On Tuesday, March 5, 2013 11:53:2
Just Trim the date value in Column H
Regards
Prince
On Tuesday, March 5, 2013 10:24:03 PM UTC+5:30, JohnA wrote:
>
> I have a download into Excel with start and stop cells which contain the
> date/time. I need help making my formula work please to get the NET
> minutes.
>
> Please see my at
Hello Dear Gurus
I have a large worksheet with huge numbers of rows and columns. What I want
is that when I filter a row all irrelevant (empty) columns should hide
automatically. Please help as a lot of time is wasted on daily basis while
hiding and unhiding columns.
Thanks lot.
--
Are you
Did you try offset?
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ferreg...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 6 Mar 2013 09:53:53
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need excel to find a value in the next row's
excel IF max value in top row, then excel shows me the value from the same
column in the next row
I need excel to find a value in the next row's cell back on the highest
value of the previous cell. Example:
-4%, -6%, 2%, 0.34%
4%, 2%, 1%, -0.50%
3%, -1%, 3% , -1%
Above you can see
Can you share the excel file
how would you like to see the output and also if possible make changes in the
data of last row thr are two cells with 3% and I think you have to pick first
instance
Regards
Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ferreg...@gm
Hi xls
visit this
http://forums.codeguru.com/showthread.php?301647-Permutations-Combinations-Problem-in-VBA
Regards
Ashish
On Wed, Mar 6, 2013 at 6:57 PM, Prince wrote:
> Yes it can be done but by using VBA Only.
>
> regards
> prince
>
>
> On Tuesday, March 5, 2013 10:45:03 PM UTC+5:30, XLS
HI
if you are using Excel 2007 + version . you can simply record the macro -
of highlighting duplicate cells and see the code and use it as per your
requirement
or visit this and use it as per your requirement
http://www.automateexcel.com/2008/10/13/vba-highlight-duplicates-in-a-range/
Regards
Dear Experts,
In a spreadsheet I have more than 1000 rows, in that I want to find duplicate
entries with the help of macros & row as to get highlighted
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard condition
Hi Manjunath
try this
Sub Macro1()
Cells.Replace What:="0", Replacement:="", LookAt:=xlWhole, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub
On Wed, Mar 6, 2013 at 8:47 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
hi prince,
As per VBA code entire data is getting deleted from sheet. Just want to delete
0(Zero) from the sheet.
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 06 March 2013 13:26
To: excel-macros@googlegroups.com
Subject:
Attached.
-- Forwarded message --
From: अनिल नारायण गवली
Date: Wed, Mar 6, 2013 at 9:52 AM
Subject: Re: $$Excel-Macros$$ Folder path to be given to consolidate the
data from different files
To: excel-macros@googlegroups.com, isk1...@gmail.com
Dear Pravin,
Pl share the workbook
good solution XLStime..
On Wed, Mar 6, 2013 at 4:06 PM, xlstime wrote:
> another way
>
> press Ctrl+H
>
> in find what enter Alt+ 0+ 1+ 0 (press alt then 0 (zero) then 1 (one)
> then 0 (Zero)
> and replace all
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Mar 6, 2013 at 3:30 P
good solution viper..
On Wed, Mar 6, 2013 at 3:51 PM, The Viper wrote:
> =SUBSTITUTE(A1,CHAR(10)," ")
>
>
> On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote:
>
>>
>> Hi,
>>
>> I want to remove all enter.
>>
>> Regards,
>> Kuldeep Singh
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce
Yes it can be done but by using VBA Only.
regards
prince
On Tuesday, March 5, 2013 10:45:03 PM UTC+5:30, XLS S wrote:
>
> yes..
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Tue, Mar 5, 2013 at 10:42 PM, rajan verma
>
> > wrote:
>
>> so you want all possible unique combination
By using VBA :
Sheet1.range("$A1$AZ1048576").clearcontents.
regards
prince
On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote:
>
> Dear Sir,
>I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
> would like to BLANK or DELETE the numeric 0 , [Other cells
i think you are very very beginner in excel
=Concatenate(A1,A2)
=A1 & A2
On Wed, Mar 6, 2013 at 4:51 AM, Dhaval Shah wrote:
> dear friends
>
> i want to merge two text cell in one
>
> pls refer the sheet
>
> thanks
>
> dhaval
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
dear friends
i want to merge two text cell in one
pls refer the sheet
thanks
dhaval
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use conci
Thanks Anil for that much help
But still when I run your defined macro 'Sheet3' it change nothing.
I also try to call that function using '=Sheet3()' but not working
Am I wrong in calling that function
On Wednesday, March 6, 2013 4:23:02 PM UTC+5:30, अनिल नारायण गवली wrote:
>
> Dear Anu,
>
>
Hi,
use this =SUBSTITUTE(A1,CHAR(10),"")
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote:
>
> Hi,
>
> I want to remove all enter.
>
> Regards,
> Kuldeep Singh
>
> --
>
> --
> To post to this group
Hi Anil
Thanks for ur help
But I do not have much knowledge about macros as I have just started
working on it. can you explain little bit more as an I need to do
something with code or else for
Selection change event
On Wednesday, March 6, 2013 12:34:38 PM UTC+5:30, anu.r...@gmail.c
another way
press Ctrl+H
in find what enter Alt+ 0+ 1+ 0 (press alt then 0 (zero) then 1 (one) then
0 (Zero)
and replace all
.
Enjoy
Team XLS
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote:
>
> Hi,
>
> I want to remove all enter.
>
> Regards,
> Kuldeep Singh
>
>
=SUBSTITUTE(A1,CHAR(10)," ")
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh wrote:
>
> Hi,
>
> I want to remove all enter.
>
> Regards,
> Kuldeep Singh
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this for
Hi Gawli Anil,
Please check all mails. It's Kannan (kannan.ex...@gmail.com) Query. I have
no query. I am happy to help.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the en
Dear Kuldeep,
Pl provide proper query. What do you want??
Warm Regards,
Gawli Anil
On Wed, Mar 6, 2013 at 2:54 PM, Kuldeep Singh wrote:
>
> Hi Kannan,
>
> PFA..
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
>
Hi Kannan,
PFA..
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Wed, Mar 6, 2013 at 2
pls share the data
On Wed, Mar 6, 2013 at 2:45 PM, xlstime wrote:
> please share required field
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Mar 6, 2013 at 2:09 PM, kannan excel wrote:
>
>> hi friends i want courier management data format in excel
>>
>>
>> regards
>> kann
please share required field
.
Enjoy
Team XLS
On Wed, Mar 6, 2013 at 2:09 PM, kannan excel wrote:
> hi friends i want courier management data format in excel
>
>
> regards
> kannan
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =T
hi friends i want courier management data format in excel
regards
kannan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
34 matches
Mail list logo
