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
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 For
select sheets tab with control button and press alt h h
On 28 Sep 2013 13:04, ashish koul koul.ash...@gmail.com 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
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
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?
A formula likes can give you an idea
=COUNTA(B:XFD,A2:A1048576)
On Sat, Sep 28, 2013 at 2:19 PM, Rajesh Agarwal rajey...@gmail.com 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
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:
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
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
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
10 matches
Mail list logo