Sub deleteline()
Dim rngRange As Range
Dim rngCell As Range
Dim rngUnion As Range
Dim strvalue As String
Dim intcolumn As Integer
Set rngRange = ThisWorkbook.Worksheets(1).UsedRange
intcolumn = InputBox("Please enter the Column Number,where you have
that value
Hi,
I need a help from the group. I nedd to do a macro that delet a line in
the sheet if is not the value I´m looking for. For example in the sheet
above, I want only to keep the lines with “k” in the first cell. All the
other lines I need to delete, so the first line, the third and below
How to connect MS Excel to Mysql table and edit data in database ?
Im stopt on this point. In Ms Excel over Mircosoft Query I chose Source of
connection to MySql throe ODBC pickup my table and make import of date.
When I change the date. How to ‘return’ to MySql this information ? In Ms
Off
Respected Experts,
I think many of our experts would like to participate in Excel Financial
Modeling world championship to be held in October 2013.for details go in to
Microsoft website or go the the link:
http://blogs.office.com/b/microsoft-excel/archive/2013/09/24/invitation-to-join-modeloff-20
A formula likes can give you an idea
=COUNTA(B:XFD,A2:A1048576)
On Sat, Sep 28, 2013 at 2:19 PM, Rajesh Agarwal wrote:
> Hello Everyone
> I want to know if someone write something in any cell of the sheet for
> example in the cell "IT65514". Is it possible to find that this sheet has
> anythin
Hello Everyone
I want to know if someone write something in any cell of the sheet for
example in the cell "IT65514". Is it possible to find that this sheet has
anything written on it.
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Do we also have any specific macro for hiding few selected columns?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: 28 September 2013 13:04
To: excel-macros
Subject: Re: $$Excel-Macros$$ how to unhide multiple sheets a
select sheets tab with control button and press alt h h
On 28 Sep 2013 13:04, "ashish koul" wrote:
> Sub unhide_specific_worksheets()
>
> Dim abc()
> Dim wk As Worksheet
> Dim i As Integer
> abc = Array("Sheet1", "Sheet2")
>
> For i = LBound(abc) To UBound(abc)
> For Each wk In ThisWo
Sub unhide_specific_worksheets()
Dim abc()
Dim wk As Worksheet
Dim i As Integer
abc = Array("Sheet1", "Sheet2")
For i = LBound(abc) To UBound(abc)
For Each wk In ThisWorkbook.Sheets
If wk.Name = abc(i) Then
wk.Visible = xlSheetVisible
Exit F
Website...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Saturday, September 28, 2013 11:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take the data from the webpage table and
paste it in the ex
10 matches
Mail list logo
