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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Variable Help22 Dec 2007 23:46 GMT3
I'm sure this is an easy task for the experts around here, but I'm having
some troubles strating out. Basically I would like to be able to bring a
gross margin value from our "Costing" and then recall that value onto a
"Change Order Sheet". That much is simple enough, but next I ...
create macro "merge selected cells"?22 Dec 2007 22:57 GMT7
I want to create macros that relate to selected cells, not absolute or
relative references; specifically, merge and unmerge selected cells. Excel in
Office 2003, Win XP.
How to iterate through columns?22 Dec 2007 22:18 GMT1
I have a particular issue with columns.
I have 4 columns. I need to iterate through the 4 columns (say H - K).
The values in the columns are put there from a database record set.
The record set, therefore, has a row length that could be variable,
expanding numbers?22 Dec 2007 21:51 GMT7
I'm not sure how to title this post. But this is what i want to do.
I need to take two variable numbers say 75 and 30000.
Then I need to step out the difference over a variable amount of cells. in
this case say 20 cells.
VBA to select the cells next to the result of a find & combine the22 Dec 2007 20:39 GMT4
I've got data that always appears in the two cell immediately to the right of
a cell that contains "Case:" that I'd like to select.  In other words if
"Case:" appears in C33, then the two cells I want to select are in D33 and
E33.  The trouble is the row isn't always the same ...
rotate highlighting colors macro22 Dec 2007 19:11 GMT2
I need to create a macro that when pressed will cycle through a number
of highlighting colors.
So for example when I press the shortcut the first time it will change
to yellow, a second time change to red, a third time to grey etc. etc.
Open with Openform; Workbook not visible22 Dec 2007 18:20 GMT1
Is there a way to open an Excel workbook only showing a Openform (not showing
the workbook at all)? I would like it to start with a openform asking a
question; upon the response, it will open the workbook.
Worksheet_BeforeClose conditional Worksheet change22 Dec 2007 18:20 GMT3
Trying to make the following macro dependant on any change in the active
worksheet. In other words it should not be inaugerated if the the file just
is opened for view or printing, but only when any cell in the sheet is
changed. Can worksheet change be used? Does anybody have a ...
sort issue: Excel seems to be treating my column of numbers     "alphabetically"22 Dec 2007 15:01 GMT4
I am trying to sort a column of numbers in numerical order. When I
attempt to do this excel seems to want to sort them as though they
were letters. Here is an example:

deleting multiple rows22 Dec 2007 14:53 GMT3
I need to delete subsequent rows, but i have to address the starting and the
end points by referring two cells.
I mean i dont want to use this:
Rows("2:5").Delete
date confusion22 Dec 2007 14:43 GMT3
general question here guys,  I get a report that is in CSV form on a weekly
basis that inludes dates. Some of the data has the date format reversed.
i.e. 02/01 instead of 01/02.
I am ok with the logic of sorting this issue BUT, sometimes the data
Change name of pictures in worksheet22 Dec 2007 14:35 GMT1
I'm making a NFL playoff bracket - So I've copy and pasted the helmets
of the teams over drop downs and am using ActiveSheet.Shapes("Picture
47").Visible = True then ActiveSheet.Shapes("Picture 48").Visible =
False to show the correct helmet.
Custom List22 Dec 2007 13:40 GMT1
Thanks for any help.
This is on Custom List which I know how to create, my question is, Is
there a way to name a custom list? What I want to do is create a time
schedule starting at 7:00 and go from there every 15 minuntes till
Chart label questions22 Dec 2007 10:50 GMT1
I have three questions about chart labels. I have labels on a bar
chart. I have it programmed where the cell value in D5 is inputted
into the label. First question. On my chart the on primary y axis is 0
and the scale is -.4 to .4, so 0 is in the middle of the chart. (this
getting the active chart/chartobject's name22 Dec 2007 10:13 GMT4
Given the code below, does anyone have any suggestions on how to
obtain the active chart/chartobject's name so that I can address
Shape(name) properly when I try ot move the shape?
[code]
 
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.