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 associat
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
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 wrote:
> That's not true.
>
> MATCH("A",**L6:L27,0) is not equal to MATCH("AA",
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 wrote:
> Hi
>
> Replace
>
> Flg = Evaluate("ISNUMBER(LOOKUP(9.**999E+307,SEARCH(D18,
is indicating that the report has already been run. It
seems to be seeing the AA as a match
On Sat, Mar 10, 2012 at 7:25 PM, dguillett1 wrote:
> isnumber is based on the SEARCH returning same
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
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 p
t" 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
> Depend
+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 t
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 wi
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 are
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 D
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
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 con
In column a from row 4 to row 52 I have a list of numbers. however
some cells are empty. I need to remove the empty cells so that i
have a list of numbers from row 4 downwards with no empty cells
inbetween. I cannot delete rows as I have other data on the
worksheet. I need to do this in VBA.
Thanks,
Problem solved
On Oct 22, 3:57 am, abhishek pandey
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 wrote:
> >
I have designed a number of macros in Excel 2003 and had no problems
when I upgraded to 2007. However I am having problems reported for
users using my macros in Excel 2010
I do not want to upgrade to Excel 2010 at this time and I was
wondering if there is any compatabilty checker I can use in Exc
can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
>
> From: Brian
> To: MS EXCEL AND VBA MACROS
> Sent: Fri, September 9, 2011 12:56:1
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 pe
entered.
In Textbox1 I am enetering the date when a member joined and this is
the date that is being reversed to mm/dd/ even though I enter it
as dd/mm/ (my windows setting)
On Sep 2, 7:23 pm, NOORAIN ANSARI wrote:
> Dear Brian,
>
> See attached sheet if it help..
>
>
>
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 easie
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.
-
Combine the cells like so... A1&B1&C1 etc then use COUNTIF
with the coniditional formatting. For example in G2 put
=A2&B2&C2&D2&E2 (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, "
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 A
24 matches
Mail list logo
