Programming

Hiding Columns
Is there a piece of VBA code that will allow me to run a macro at a push of a button that will hide or unhide columns in a workbook dependant on a given criteria in say row A ? For example if columns A, B, C & F, & H has a ?1? in then leave and if columns D, E, & G has a ?2? then ?hide? ? Many thanks Andy ... 20 Jan 2006 03:56

VBA VLookup
I can't see an obvious problem with the VLookup at the end of this code, but I get an error 1004, 'Unable to get the VLookup property of the WorksheetFunction class'. Could someone point me in the right direction? Sub NodeAddress() Dim LRow As Long Dim LRow2 As Long Dim c As Range Dim mystring As String Dim... 16 Jan 2006 18:56

Web Query
I am looking for the a way to address the following scenario, there are a number of different options but I would like to hear opinions on the best approach. I have an Access database with a table of stock codes I wish to periodically obtain the price of from the web for each code in the table. Once the pric... 14 Jan 2006 12:22

Find Macro
I have a workbook with multiple sheets and thousands of entries. I would like to search the workbook for entries that would be similar to this: abcde-s-1234 or efghij-s-56789 The only common this is the -s- in the cells that would be 5 or 6 places over from the left. I would like to locate all the -s entries... 13 Jan 2006 18:13

Posting times to an Excel spreadsheet
I am trying to post the finish times for a 5k race to an excel spreadsheet. However, everytime the minutes are higher than 24, Excel automatically formats it to read in military time. For example: If I enter 24:53, Excel changes this automatically to 0:53. This messes up the finish time is there any way... 5 Feb 2006 05:49

Excel Date Problem
Hi Guys, Can you help me with a little problem. I am running a macro on a csv file. There are 4 dates in the format dd/mm/yy and I format them to dd mmm yyyy. So the cell A1 originally has the value 25/12/05, I format it so the cell A1 now has 25 Dec 2005 When I try to concatenate "Date Reported : " & A1. I... 3 Jan 2006 11:24

ROI Spreadsheet
I've been looking for an Excel s/s that will perform financial ROI's, including periodic additons/withdrawals, such as the online app found at http://cgi.money.cnn.com/tools/returnrate/returnrate.jsp. I've searched high and low to no avail. I want this app for a website that tracks investments for its users fo... 3 Jan 2006 00:56

Save Macro
I'd like a macro that, prior to saving the current workbook, would position the cursor in cell A1, and make the first sheet the active one. The following code does not work. Can anyone help? Public Sub SaveWorksheet() Dim wrksht As Worksheet For Each wrksht In ActiveWorkbook.Worksheets Range... 29 Dec 2005 13:42

Setting an Essbase Option using code
Hopefully someone can answer this question I have declatred some functions in a module and one of these statements is Declare Function EssVSetGlobalOption Lib "ESSEXCLN.XLL" (ByVal Item As Long, ByVal globalOption As Variant) As Long I want to set the zoom option in essbase to next level (which is the first ... 29 Dec 2005 12:40

Basic question
I have a very basic question but I can't seem to find the answer on here (probably to basic). I have a spreadsheet that I would like to perform all of my calculations / If / Then statements using VBA but I'm not sure how to actually get the code to run or where to put it to run... I can get all of the code to r... 28 Dec 2005 15:54