Leave loop
Wed, 15 Oct 2008 13:37:49 -0700 (PDT)
so I have this part of the loop doing what I want.
For i = 3 To 100
Worksheets("Shapes").Range("I5:I7").Copy
If IsEmpty(Worksheets("MAG").Cells(i - 1, 1)) Then
Worksheets("MAG").Cells(i - 1, 1).PasteSpecial Paste:=xlPasteValues,
Transpose:=True
Next
However, I want it to stop right after it pastes and lea ...
|
"Sumif " across worksheets?
Wed, 15 Oct 2008 20:47:42 +0100
Not sure if this is a programming or function group query so apologies if wrongly posted.
I have a variable range of worksheets. In each worksheet in the cells C41:C46 there are
names, all of these cells may or may not contain a name. If any are missing it will always
be the last cells in the range of each work ...
|
Selecting data with a specfic value only
Wed, 15 Oct 2008 12:33:03 -0700
Hello all,
Excel 2007
I obtain a dump of data into an Excel spreadsheet. I cannot change the
requested data from the data dump, it simply gives me all the transactions
for every client. I wish to extract from this dump of data only the
information for one specfic client. I would like to write a macro to d ...
|
Refreshing a SharePoint list in Excel
Wed, 15 Oct 2008 12:14:36 -0700 (PDT)
Hi,
I've got a list in an Excel file that's linked to SharePoint. If I
right click anywhere in the list and choose List > Discard Changes and
Refresh, the list refreshes fine. However, if I use the VBA
equivalent - ListObjects("List1").Refresh (the code that the macro
recorder even creates) - I get an appli ...
|
Wild card in formula
Wed, 15 Oct 2008 11:51:02 -0700
Greetings all. I am trying to use a SUMPRODUCT formula to calculate a
number, but I need to be able to use * or LIKE, or something with the same
results. I have the following, and of course it does not work
=SUMPRODUCT((A6:A100 = "*COURSES")*(B6:B100))
I will have several more columns involved once I get ...
|
File exists, but code doesn't find it?
Wed, 15 Oct 2008 14:33:32 -0400
I have some code that looks for a file; if it doesn't find it I need to exit
my sub because the rest of the sub clears my worksheet and imports new data
from the file. If the code runs without the file present, it clears my sheet
but doesn't have anything to import- which messes up a lot of subsequent
stuff. ...
|
RE: Remove small square caused by vbCrLf
Wed, 15 Oct 2008 10:57:06 -0700
Tom,
I have a small square that appear in a column of formula cell (a formula
that is combining text from a number of other cells). I don't know what VvLf
and vbCrLf refer to so I can't use your advice. Can you explain it to me?
The cells are formatted for word wrap. I am using 2003. Thanks so much!
"Tom ...
|
|
|
Toolbar position
Wed, 15 Oct 2008 10:42:01 -0700
I have a custom toolbar created when a worksheet is opened, however I want to
place it next to another toolbar everytime it is opened. I have used the
following code:
MyBar.RowIndex = Application.CommandBars("OtherBar").RowIndex
MyBar.Left = Application.CommandBars("OtherBar").Left
This would work except ...
|
Delete blank rows
Wed, 15 Oct 2008 10:09:02 -0700
Hello,
I'm returning some address lines into separate cells, some of which will be
blank.
Is it possible to delete the blank lines using some form of macro?
Cells A1:A6 contain the data. Cell A2 will always be populated, but the
remaining 5 can be blank
Sample
A1 - Address line 1
A2 -
A3 - Town
A4 - ...
|
Challenging - Can an existing SSIS package be run from Excel using
VBA ?!
Wed, 15 Oct 2008 10:03:23 -0700 (PDT)
Hello,
Just wondering if it is possible to call and run an SSIS package using
Excel 2007 VBA ? I suspect not but if anyone knows it'll be the power
users of this group.
Thanks for any help
Jason ...
|
