If the Range is $E$10: $E$20 and named Fred how does one select the
Range omitting the first cell in the range. If that can be done how
does one omit the first and last cell in the range.
The reason for asking is that I am trying to avoid breaking the macro

I have a macro that runs Find, but I've added a wrinkle to it. It will
locate a cell. What I need is the proper code to move to Column A of
that line. I can't just move X number of cells to the left, because I
don't know which column the Find will land me in.

I'm trying to create a function/sub that will automatically push data
from an excel sheet out into Access in order to log history of this
specific sheet.
I have everything set up within access including the necessary macro

This is part of some code I wrote to limit acess to some spreadsheets.
It's supposed to ignore the sheet "(Code Key)". But it still asks for a
password.
Private Sub Workbook_SheetChange(ByVal ws As Object, ByVal Target As

Hi all - sorry about this odd question, some years ago i belonged to
the group excel-g, is this the replacement? i see Don G  is still
around  and is at least one familair name - i haev a question i want to
post but want to make sure i start off in the right group.

I need a Macro to dump certain cells in a worksheet into an access
database.
This will be done on a daily basis - I want them all on the same
database.

SORRY IF THIS IS A 2ND POSTING BY ACCIDENT BUT, IF SO,
PLEASE READ THIS ONE NOT THE PRIOR
A file I have contained one worksheet that was a cosmetically pretty echo of
another of my worksheets that was full of actual inputs, many of which I

I'm really want to find out how to put this metacode in Excell
' CounterDay represents the columnnr where the calculation has to
happen. Starts on row 31 untill row 365
' CounterV is the counter to count the number of V's he finds (it

I have the following issue, I will make a simplefied explenation here.
I have the Following Data
   A    B    C
1        1

I have the following Code that that works great under Office XP/2003
versions except one problem PC that uses Office XP and Windows 2000. I
have a Reference set to Microsoft VBA Extensibility v 5.3. Is there an
issue with running code via VBA to insert Code into ThisWorkbook under

Dear Excellences,
we have an Excel table wich is modified via VBA code. This works
perfectly. At the end, this table has to be saved as *.txt file. When I
do this manually, I can retrieve the table easily. Especially, the

I used this statement in a macro I created in 2000. I think it should
be capable of modifying to it make more usable in other situations.
   Range("PAGEHEAD").Select
   Dim Y

I'm not entirely sure how I should explain this, so here goes:- I am
trying to create a user interface with [not entirely sure about this
yet] tick boxes/ comboboxes where the user will select a number of
statements/ or titles of statements from the userform which will be

I found the following code to add items to a combobox in a userform for
Excel 2002 , and works just fine in version 2002.
Private Sub UserForm_Initialize()
'   Executed before the form is shown

i have the following code :
For Each cell In ThisWorkbook.Worksheets("Programs").Range("C2:C" &
(MaxRecords + 1))
...