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 / April 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Compare two columns, delete rows that match?24 Apr 2008 08:31 GMT1
I would like to compare columns B and C, and, if they match for a given row,
delete or hide that row.   B and C will be numbers (A is text) and as I am
new to development in general, I unfortunately have no code to post.  Any
help would be much appreciated.  Since this tool will ...
VBA / Formula24 Apr 2008 08:18 GMT2
I have a formula I am trying to put into vba format.  I have the formula
working fine in the cells themselves, but it takes a long time to calculate
and recalculate.
Can anyone help me put this formula into the proper syntax?
Edit VBA Code without opening the workbook24 Apr 2008 07:45 GMT9
I have VBA event code in an EXCEL workbook that goes into a never-ending
loop. I know what the problem is -- it triggers its own event! -- but I don't
know how to edit the errant code without opening the workbook. Is there a way
to edit the code without opening the workbook?
Save & Load A Range24 Apr 2008 07:33 GMT5
Wonder if something like this is possible - 'air' code to show
example.
--
Dim zz As Range
Help with Vlookup of Find date24 Apr 2008 07:28 GMT1
I would like help.  I have a workbook open.  I would like to look at a
closed workbook or or open it whatever it's name may be (changes every week)
at column B2 to B80 and find the corresponding text in the same location as
my open workbook.  In the closed workbook I would like ...
Dynamic comboBox on Ribbon24 Apr 2008 05:34 GMT5
Is there a good example of how to dynamically populate a comboBox on a custom
tab on the Ribbon? Say from a list of items on a spreadsheet or from an array?
If so, could you point me to it?
Thanks much in advance.
replace copy and paste24 Apr 2008 04:50 GMT2
I have below macro recorded and would like to replace copy and paste
with = Formula if possible.
Range("D8:H8").Select
   Selection.AutoFilter
I need help with a "Run-Time Error 13: Type Mismatch"24 Apr 2008 04:35 GMT2
Hi group.  Im getting an error that I dont understand with this macro
I wrote for excel.  Im a begineer to VBA but this code also stumped an
experienced programmer that i showed and I would really like to know
what the problem is.  If anybody would care to read through it (I
If ...Then Statement24 Apr 2008 04:26 GMT8
Group,
I have a worksheet change evenet that I want to be able to toggle with a
named cell value.
Private Sub Worksheet_Change(ByVal Target As Range)
Code format question24 Apr 2008 03:31 GMT3
Hi Group,
Just for the life of me can not remember the code which I used in the past
to format combined variables. First Variable should be (Fixed,Comma,2) and
the second should be as a %. It is the Fixed, Comma, 2 I am having trouble
Using More than 7 possibilities in a formula24 Apr 2008 02:14 GMT2
How do I use more than 7 possibilities in a formula.  I know basically you
can't nest more than 7 formulas in one.  
Any suggestions would be helpful
Previous active cell24 Apr 2008 00:41 GMT2
Is there a way to capture the address of the last previous active cell.  I am
trying to do this in the selection change code of a sheet but I cannot make
it work.
Thank you,
Excel 2007 Macro Security24 Apr 2008 00:20 GMT3
I used a tip from this forum on using the Workbook_Open event in Excel 2003
to determine if macro security levels would allow macros to execute.  With
that, instructions could be provided to the users on how to change their
macro security level in order to run macros in Excel ...
Refresh form24 Apr 2008 00:14 GMT1
To update the items on a userform I am using "userform.hide" and
"userform.show" at the beginning and end of the procedure.  Is there a better
way to update the data on a userform?
Thanks
Protecting sheet through vba while allowing some actions24 Apr 2008 00:12 GMT3
I've done a lot of searching on this but am stuck - I'm guessing the answer
is simple - basically, I have a large file with 65 sheets -- on 15 of these
sheets, I would like to have them protected, but still allow the user to do
things such as sort, autofilter, format, and a few ...
 
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.