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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
adding daily totals to weekly totals28 Mar 2008 15:26 GMT3
I have a spreadsheet called daily data  it has two columns of data, at
the end of the day I want to copy the values in column b and paste
them to the spreadsheet weekly data.  Each column in weekly data has
values grouped in week ending columns i.e
A little Macro Help Please ...28 Mar 2008 15:20 GMT15
Excel2003 ... I know nothing of VB Code ... I record Macros only & then
perform a little creative cut/paste as needed ... That said ... I have the
following recorded Macro instruction:
   Range("A2").Select
Search Companion28 Mar 2008 15:05 GMT1
I am using Excel 2003 and and my operating system is Windows XP.
Using Excel VBA,is there any way to activates the Search Comapanion? I have
tried Application.SendKey ("^{ESC}") but it does not work.
Obtain Name of Function or Sub28 Mar 2008 15:04 GMT6
Hi Experts
I would like to include the name of the current function or subroutine in my
error handler output. Is there any property that will provide the name or
context of the current point in the call chain?
Get the path of the .xls file28 Mar 2008 14:48 GMT2
I currently am using one workbook to open another, now the sheet I open is
always located in "\HolSheets\holSheet.xls" and the original workbook is in
the folder that is the parent of the directory HolSheets. This will always be
so, yet not sure where they want me to copy the ...
VBA problem after Excel update?28 Mar 2008 13:58 GMT1
I have a VBA script that I use to convert CSV-files from a TDS1014
oscilloscope.
With this script I can open a CSV-file, convert it with the macro, and then
open
autofilter average values28 Mar 2008 13:38 GMT2
I have a table with the following headers
Range (A1:L1)
segment 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
I have a list for which I filter this table according to segment and I
Finding, copying and pasting28 Mar 2008 12:44 GMT1
I want to get some code that will do a few functions for me. I have a
worksheet with 1000's of entries and I want to find and use only about
15 of them. I can find them by their name which is displayed in column
A, I then want to select the whole row and add it to a new worksheet.
macro for serching syllable in a word28 Mar 2008 12:41 GMT1
 I am looking for a macro that reads a word from one cell and gives
back more stressed letter in a word..say for an example "Highwave "
will have to return H,W
Identify second line28 Mar 2008 12:19 GMT2
I have a strange issue, in a cell I have two lines which is entered by the
user using alt+enter. Now I need to segregate only the second from each cell
& manipulate teh data furhter. This data is full of text.
for eg: NCO
return item from second column from2 column combobox28 Mar 2008 12:04 GMT1
I am using cboMonth3(cboMonth3.ListIndex - 1, 1) but I get type mismatch can
someone help please?
Regards
Charles
adding data to one olumn to another28 Mar 2008 11:34 GMT1
I have two columns of data column a is always the same coloum b get
filled out every week with numerical data for instance
data1       10
data2        9
Formula to sum non-adjacent cells28 Mar 2008 09:49 GMT7
Excell 2003
I have a 3000+ line spreadsheet with totals in one column every 17th row.
What formula can I use to sum these totals?
Thanks
AutoFilter Blue Arrow28 Mar 2008 09:27 GMT2
I found an  article here:
http://www.contextures.com/excelfiles.html#Filter
Article
FL0014 - Colour Filter Headings -- Event code colours the filtered column
Adding an input box to a custom toolbar28 Mar 2008 08:36 GMT3
is there a way to add not a button but an input box into a custom
toolbar in excel. I would like the user to type some text in the
toolbar, press enter and a macro would launch at grab the text. I
think it is feasible, but I can't see any article/post/webpage on the
 
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.