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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
clear cells containing specific values21 Sep 2007 22:00 GMT7
If someone can help me on this:
I have
        column       A
row1         28th street market
Aligning buttons21 Sep 2007 21:38 GMT1
I have a group of buttons in the spreadsheet. Is there a way to align
the buttons. I've been just kind of eyeing them in the past to get
them straight.
Thanks,
VBA - array or collection literals?21 Sep 2007 20:52 GMT2
Currently, I have written a function to do some sort of pattern
matching:
Dim delims As New Collection
delims.Add " <"
code is not selecting correct range21 Sep 2007 20:42 GMT3
I have a strange problem -- the macro is not selecting, copying or pasting to
the correct ranges.  When I do a F8 step by step debug review, it seems as if
it actually skips the Range(...).Select code.  
The new select and paste ranges that are not be selected properly were
macro for arranging by Contract #21 Sep 2007 20:38 GMT3
Hello experts,
I am trying to arrange information by contract # or by date.  I produce a
material everyday and input the information into the spreadsheet the latest
is the last line but the contract #'s vary per day (See example #1).  I want
complex IF statement21 Sep 2007 20:34 GMT5
In cell $E$70 I have a data validation drop down list which allows the user
to select a percentage between 0% and 10%.  I am trying to get cell $D$70 to
read "Product Subtotal at 1% discount" when cell $E$70 is 1%, "Product
Subtotal at 2% discount" when cell $E$70 is 2%" etc.  
Change the worksheet tab name updates hyperlink on first page?21 Sep 2007 20:32 GMT2
The subject essentialy is what I want to accomplish.  Also if when I update
the tabs (rename or add a new one) the list of hyperlinks adjusts
automatically? If it needs to work the other way around that would be ok as
well. (hyperlink edits result in tab name edits and/or ...
select listbox item21 Sep 2007 19:27 GMT1
hi,
i would like to know how i can select a listbox item using vba.  i tried:
for x = 0to sheets("sheet1").listname,listcount - 1
sheets("sheet1").listname.item.select
Pick value off sheet list for VBA code determination21 Sep 2007 19:10 GMT2
Apologies for the cross post.
Here is a sample of VBA code used to place a value in a cell base on
the value entered in the cell previous
If LCase(.Value) = "capital" OR _
Please help with coping cells21 Sep 2007 18:24 GMT4
I have the following sample of data in an excel sheet. This lay out is
repeated for couple hundred rows in exactly the same fashion.
********************************************************
Building  Primate Clinic  CRV($000's)  $603     Building Number 504    GSF  2,455   
convert multicolumn/multirow table into two structured/formatted columns => feasible?21 Sep 2007 18:10 GMT7
I know this is an extremely tough one and I don't expect here any final
answer on this - some enlightening guidelines (f. ex. if it's feasible...)
would be already great!
I have a huge excel table (database) that involves child (unique) and parent
runtime error 100421 Sep 2007 17:44 GMT1
hi,
i have the following code behind a button in sheet1:
sheets("pivot").select
range("F2").select
Assigning a macro to a picture21 Sep 2007 17:18 GMT3
I was tinkering with an image in Excel 2003, right clicked, chose assign
macro, and clicked OK instead of cancel. Now, everytime I left click on the
image to try and select it, I get an error message about a macro not being
found.
GetWindowsDirectory in Vista21 Sep 2007 17:08 GMT2
I've been successfully using a programmed spreadsheet that first writes to on
Windows XP that reads from the Windows Directory. I now need to use it on a
Vista machine. It doesn't seem to find the Windows Directory. How do I find
it?
Code modification?21 Sep 2007 16:52 GMT2
I was graciously provided a macro that deletes all rows not having certain
values in col A. In the following line:
ArrNames = Array("Agt", "Agent")
Is it possible to add a wildcard to "Agt"? Those are just the first 3
 
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.