I am currently using the following VLOOKUP formula in a spread sheet
=VLOOKUP($A3,Leadtime!$A:$BD,3,0)
What I am wanting to do is copy formula across the row for the next 50
columns.  When I do this all column result '3' is copied also.  What im

I have a table as shown below, I want to create another one that put all
Territory together into one cell that corresponding to unique County.
County      Territory
Bell    0033

I am trying to use the following macro from Rondebruin's site, but am
encountering an error at "wb.SaveCopyAs "C:/" & WBname". Any ideas?
Also, is there a simpler way to get the email to open through Outlook,
rather than putting in server details (see below)?

I'm developing software which transfers data from serialport to Excel sheet.
The problem is software crashing while cursor is in cell and data is written
to cell. In this project user MUST be able to modify/write cells sometimes.
This is what I'm gettin: Call was rejected by ...

Simple formula to insert a SUM.
Range("G22").Select
   Selection.End(xlDown).Select
   ActiveCell.Offset(2, 0).Select

My first experience with protecting and opening a protected workbook.
   - In my app, I open two workbooks, one of which is protected.
   - After opening, when selecting the protected window, the sheet is about
5/8 the size of the screen, as if it were partially minimized.

Hi! I have a spreadsheet that I have gotten from someone else. On that
spreadsheet is a button that runs a a macro when pressed. However I cannot
move the button or delete it as I can with other buttons placed on a
spreadsheet normally. When checking the code for the spreadsheet ...

One of those bang your head against the wall ones...
FYI - ExcelXP, if it matters.
Everything i read says that setting Cancel = True in Workbook_BeforeClose
should prevent the workbook from actually closing, i.e. prevent the built-in

I have some data which is stored in an array. At the moment my VB programme
prints the array into Excel (which is rather time consuming as the array has
8736 entries) then graph it directly from Excel. I have managed to create a
graph using my array but it seems that I can only ...

HI!,
I am trying to find a date from an activecell but i get the error message
"object variale or with block variable not set"
From the bellow Sub

Is it possible to import a whole sheet from one xls to another,
including the colours, layout and any comments associated with cells?
Thanks - Kirk

Hi;
I have several named ranges eg "Bar1, Bar2, Bar3 etc" .  Each represents 1
column I want to lock.  I want to lock and on lock them as a group.  I have
tried every way I can think of to use 'Set' but I keep getting error

I found the below code on this board (I think it originated from Tom
Ogilvy). I need to put the generated numbers in a row but the list generated
is designed for a column (if this makes any sense at all).
Its probably simple but I am new at this stuff and would appreciate any help ...

Sorry, had to put the question in this Forum as did not see Vision forum
separately.
Q: I am trying to create a detailed report in Vision and when I select the
table name, I am not able to view all the fields available. I specifically am

I am having difficulties in creating a VB code for a 'Parts Inventory'
spreadsheet.
In my 'Userform' in Visual Basic I have a text box used for entering a date
as a number eg. 290906 which will then enter in the 'Parts Inventory'