Hello,
Thanks a lot. Its working fine.
Regards,
Chandra
On Fri, Sep 20, 2013 at 12:28 AM, Excel Beginner excelbegin...@gmail.comwrote:
** **
Hi Chandra Sekar ,
** **
Use the below formula.
** **
Thanks Ravinder,
can you tell me how did you done this and also tell me how to lock the work
book as it is.
Rgds,
Prabhakar
On Friday, September 20, 2013 10:50:54 AM UTC+5:30, ravinder negi wrote:
PFA
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com
Respected Prabhakar,
Install the addin a new excel work book.To install the addin go to the
excel options button and go to the add-in tab,in the rightside down part
you will have a go button .Click it and you will have a dialog box with
brose and three other buttons.Click brose and select the
Image is not there, please send again with example excel file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Friday, September 20, 2013 2:57 PM
To: excel-macros
Subject: $$Excel-Macros$$ Auto Filter too short
In My Excel, Auto
Respected Waseem,
Just Select the entire sheet and go to any row or column intersection such
as Column A B or Row 1 2 etc.Just double click when your cursor turns
into a double arrow.Now the whole sheet is adjusted accordingly and you
need not drag it everytime.
Regards,
Vijaykumar
On Fri,
Sorry. I was saying that the field I'm selecting in my query, called xyz
is defined in the SQL table as varchar (max), which means, to me, that the
number of characters cab vary to the maximum allowed by SQL.
Rich
On Sep 19, 2013 10:21 PM, Anoop K Sharma aks.sharm...@gmail.com wrote:
Hi
--
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 thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
test mail
On Fri, Sep 20, 2013 at 5:58 PM, Ravinder ravindervbacli...@gmail.comwrote:
** **
--
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
Hello Champs,
i have written the macro below to clear the row contents if a certain
criteria is met but am getting a type match error, pls assist with proper
code.
what i want is in col L if there is dont roll over i want the information
on that row to be cleared ie only from A to Q of that
Please share your file..
On Fri, Sep 20, 2013 at 5:50 PM, Richard Mogy rm...@sbcglobal.net wrote:
Sorry. I was saying that the field I'm selecting in my query, called xyz
is defined in the SQL table as varchar (max), which means, to me, that the
number of characters cab vary to the maximum
Hi,
Replace these line
If Range(l2:l r).Value = Rolled-Over Then
Range(A cell :Q cell).ClearContents
with
If cell.Value = Rolled-Over Then
cell.EntireRow.ClearContents
On Fri, Sep 20, 2013 at 7:20 AM, Hilary Lomotey resp...@gmail.com wrote:
Hello Champs,
i have written
thanks priti for the response, the first line of code is ok but i dont
want to delete entire because i may have other information on that row in
another column, how can i manage that? is it possible? thanks
On Fri, Sep 20, 2013 at 2:36 PM, priti verma pritiverma1...@gmail.comwrote:
Hi,
Try this
Sub ROOTY()
Dim r As Long
Dim lngcolumn As Long
r = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
lngcolumn = Sheet1.UsedRange.Rows(1).Find(USER NAME ).Column
For Each cell In Range(l2:l r)
If cell.Value = Rolled-Over Then
Sheet1.Cells(cell.Row, 1).Resize(, lngcolumn).Select
one word,
S U P E R B
nicely done. thanks
can u explain this line Find(USER NAME ).Column pls thanks
On Fri, Sep 20, 2013 at 2:49 PM, priti verma pritiverma1...@gmail.comwrote:
Try this
Sub ROOTY()
Dim r As Long
Dim lngcolumn As Long
r = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
Hi!
Im updating my skills in excel and have created a spreadsheet with heaps of
dates in a column. They have 'somehow' all changed to a five digit
number! The original date can still be seen in the text bar at the top but
doesn't appear in the cell. Ive tried to format the column back to a
Try To Press Button CTRL + ` (a button before button 1, in the top of
TAB button bellow the ESC ) :D
Or
Goto Menu Formula then deactivate Sub Menu Show Formulas
On 20-09-2013 22:01, Dawn wrote:
Hi!
Im updating my skills in excel and have created a spreadsheet with
heaps of dates in a
Hi mum,
The 5 digit number is the equivalent value of the corresponding date in
that cell. You should see the correct format if you press CTRL+`
` is normally found just about the TAB key
Regards,
Sam Mathai Chacko
On Fri, Sep 20, 2013 at 8:31 PM, Dawn dawn1909simp...@gmail.com wrote:
Hi!
Hi अनिल नारायण गवली,
can you please tell me how to use your file
thanks
*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks Regards´¨)
¸ •´ ¸.•*´¨) ¸.•*¨)
(¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save
Dear Friends experts,
Good morning
If any one can helped can be appreciated,iam using excel-2010, my problem
is i want to get the result for third match(occurence) value, but
iam failed to do so.Information reg. data is explained the file.
Thanks in advance.
*Thanks Regards,*
**
*Muralidhar
PFA:-
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*10,ROW($F$4:$F$29)),3)) FOR
3RD
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*10,ROW($F$4:$F$29)),3)) FOR
4TH
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Muralidhar E
Sent: Saturday,
Hi My name is Rupesh from Pune Maharashtra, India. I am working as
technical support engineer and customer support engineer.
I am looking for VBA help. actually I have task assigned to build up tool
for data entry and I am completely new with VBA so,
Thanks and regards, Rp.
On Saturday, 9
21 matches
Mail list logo