Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
End sub routine, move to next10 Nov 2007 22:38 GMT3
I am new to VBA, but have been able to do some automation in a workbook
partially by recording a macro, by research, and a few questions to this
website.  Almost finished, but I need a little more help.  
On a worksheet in my workbook, I have a variable range, which, once found, I ...
Find a picture on a worksheet10 Nov 2007 22:38 GMT4
I it possible to serach for a picture on a worksheet via VBA, I'm trying to
see if a particular picture is visible on a worksheet if not then copy from
another another worksheet?
Thanks!
"Or" statement not working10 Nov 2007 22:08 GMT22
This Macro excerpt is based on a "Check Cell Content before continuing..."
discussion with Bill Renaud back in October.
I works great (thanks Bill) with one exception.
If the cells are changed in reverse order of my "Or" statements (Conditions
Countdown Timer - not stopwatch10 Nov 2007 21:35 GMT9
How do I write a countdown timer macro in excel if I have an end date / time
that i want to countdown till?  For example, I have in cell A1 - "12/31/2007
11:59:59 PM" and I want to display a countdown timer starting in A2 showing
"X months Y days Z hours AA Minutes BB seconds ...
2 Lists but different time frames.10 Nov 2007 21:25 GMT3
This is a snipet of my spreadsheet, this goes one untill 2007...:
    A    B    C    D    E
1        GDP             GDP
2    Jan-1981    5,307.5        1981q1    5,307.5
Average data and delete a row-need help10 Nov 2007 21:21 GMT2
Hello All, I average the data in cells B6 to B36 and place average one cell
over in C36. Once this is done, I want to delete row 6. I get an error at
line "selection.Delete shift:=xlUp" of "Object variable or With block
variable not set". Don't understand what is wrong. Below is ...
compile error, need to simplify/shorten10 Nov 2007 21:05 GMT2
I know this isn't the best way to go about this, but I a learning
here. . .
I am using this to update stock prices from a Google Finance query.  I
have a list of about 200 stocks, and when I run the below query for
Making 5 Minute Wind Averages10 Nov 2007 20:04 GMT3
Right now, I have data that is in 1 minute wind speed and direction (in
degrees) averages. I need to convert it to 5 minute averages (that is the
average from time 0-5min, 6-10min, 11-15 min and so on). I've attempted to
use the text and indirect functions to do this, but it ends ...
From Column A get Text from Colum B10 Nov 2007 19:29 GMT4
I have text cells in column B, The text cells in column B start with some
word or words followed by a space-space then the rest of text.
Example:
Cell B1
Scattered Cell entries into one Column10 Nov 2007 18:55 GMT3
What I have is scattered cells entries.  Each row has an entry I want in a
specific new column.  I am working with 'Excel 2003' and don't know squat
about programing.  I have tried filtering and do seem lost at this point to
consolidate all this data in cells to a specific column ...
Using VBA to print a range10 Nov 2007 18:54 GMT5
Hi to all out there
Hi I was wondering if there is a way of writting VBA code to print a range
in Excel 2003 with a page title this would all happen from a command button.
I could use a macro but I have always been told that VBA is the better way to
Copy formula to cells on the basis of value in row 110 Nov 2007 18:13 GMT3
Thanks for the help.
In a sheet called "Metrics", I have a matrix where row 1 is dates, So
I have different dates from B1:BD1.
Now I enter a date in one cell in a different sheet. I want a macro to
Speed Up this Macro? Part 210 Nov 2007 17:29 GMT6
Hi, Faisal.  I have one more question.  When I protect the sheet, most of it
anyway except quantities and discount, then I run this macro.  I come up with
an error on the line below.  Any thoughts?
___________For Each cell In rng_____________________
Can Excel 2003 VBA module be renamed10 Nov 2007 15:20 GMT2
I am new to Excel VBA.  Can an Excel VBA module be renamed like in Access so
I have more meaningful names that Module1, etc?
Spreadsheet to access10 Nov 2007 15:01 GMT2
Please,help
When i run the code below i get message:
"the connection can not be used to perform this operation. it is either
closed or invalid in this context
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.