I have the following code in my Excel 2007
Application.Worksheets(Log).Visible = True
and
Application.Worksheets(Log).Visible = False
on my own computer I have run this in Excel 2007, 2010 and 2013 without a
problem - I am running on Windows 7
I have given this workbook to an associate
Dear All,
I am new to VBA programming
I happen to need great and urgent help on a project that I am currently
working on
I would like to search through the worksheet, and find N or TR on row 6
Then, For every cell in the column of N or TR
if all the cells are blank, then delete/ hide the column
Kris,
Sorry, you are quite right. I made the mistake of copying the previous
code and replacing the prvious code with the previous codes.
thank you so much for your patience.
On Thu, Mar 22, 2012 at 2:49 PM, Kris krishnak...@gmail.com wrote:
That's not true.
MATCH(A,**L6:L27,0) is not
This works just as well as the other code but still has the problem, If
range (L6:L27) has the letters AA in it then it shows A as a match and says
report A is already done
On Wed, Mar 21, 2012 at 4:34 PM, Kris krishnak...@gmail.com wrote:
Hi
Replace
Flg =
*From:* Brian brianfosterbl...@gmail.com
*Sent:* Saturday, March 10, 2012 10:53 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Re: Match text to a list
Thank you Kris, your solution works perfectly. I was just wondering why
you use IsNumber when it is actually text I am
I am using Excel 2007
I have a list of single letters A to F in column H2 to H26
These letters are are mixed but only one capital letter per cell
I want to go to this list and replace each letter by its numerical value.
So A becomes 1, B becomes 2, C becomes 3 and so on to the letter F
Can you
I am using Excel 2007
Depending on the squad number I select in a worksheet I have set up some
formulas so I can find the reference for the first cell and last cell in
the range with reference to the details of the sqyuad number selected.
i then want to go to this range and copy it to another
Thanks I have attached the file
On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote:
I am using Excel 2007
Depending on the squad number I select in a worksheet I have set up some
formulas so I can find the reference for the first cell and last cell in
the range with reference
+2, Brian wrote:
I am using Excel 2007
Depending on the squad number I select in a worksheet I have set up some
formulas so I can find the reference for the first cell and last cell in
the range with reference to the details of the sqyuad number selected.
i then want to go to this range
on the
Master sheet in cell B5 I change the day and this changes the ranges and
times on the squad sheet for that day. That is why I copy the same range
4 times (once after each day change)
On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote:
I am using Excel 2007
Depending on the squad
I am using Excel 2007
In cell D18 I have some text.
I need the VBA to check if this text appears in the list in Cells L6:L27
If it does it then exits the sub otherwise it must do something else.
Can anyone help with this code.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
I am getting an error on
i = Application.WorksheetFunction.Match(Source, target)
On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote:
I am using Excel 2007
In cell D18 I have some text.
I need the VBA to check if this text appears in the list in Cells L6:L27
If it does it then exits
Thank you Kris, your solution works perfectly. I was just wondering why
you use IsNumber when it is actually text I am looking for? I mean it
works but I am just curious.
On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote:
I am using Excel 2007
In cell D18 I have some text.
I
Thanks,
Problem solved
On Oct 22, 3:57 am, abhishek pandey gjobabhis...@googlemail.com
wrote:
Hi
You can use the converter technology Office Converter or OMPM for office
2010.
Thanks
Regards
Abhishek
On Thu, Oct 20, 2011 at 10:21 PM, Brian brianfosterbl...@gmail.com wrote:
I have
-
From: Brian brianfosterbl...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 12:56:17 PM
Subject: $$Excel-Macros$$ Date from textbox reversed.
I am using a form to enter data and then from the textbox complete
I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet. This is my code
ActiveCell.Value = Date
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = FrmApplications.TextBox1.Value
ActiveCell.Offset(0, 1).Select
Activecell.Value = Date works
I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet. This is my code
ActiveCell.Value = Date
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = FrmApplications.TextBox1.Value
ActiveCell.Offset(0, 1).Select
The first entry enters the date
If you are using Excel 2007, then you can do part of this without VBA. If
you want to change color of cell, for example, when the cell value is
negative, you can accomplish this by going to Home Conditional Formatting
and then creating a rule by which the cell changes. This is probably
National Instruments website has an example spreadsheet that can accomplish
this:
http://zone.ni.com/devzone/cda/epd/p/id/798
I've expanded the ni-488.2_in_excel.xls spreadsheet from this website to do
just about anything you want to with test equipment over GPIB.
-Brian
Combine the cells like so... A1B1C1 etc then use COUNTIF
with the coniditional formatting. For example in G2 put
=A2B2C2D2E2 (you can hide column H). Then for the conditional
formatting start at A2 and use formula =IF(A2,IF(COUNTIF($G:$G,
$G2)1,TRUE,FALSE))
On Feb 24, 9:35 am, John A.
Okay, so here's my dilemma. I have 2 different systems that I am
trying to match up. System A has about 1600 lines, system B has about
1000. A is the older system and has a lot of lines that don't matter
much anymore. B has some things that aren't in A, but doesn't need a
lot of the stuff in
21 matches
Mail list logo