database input & macro

[Steve Simons]

Help!

I have a DBS that I created a macro for. The macro displays a blank data form and after the user inputs, sorts the DBS
on column B, Descending (Column B contains numbers)

The problem lies in that I want a blank column A and blank Row 1, where I can place buttons to run macros. Whenever I
do the sort, of course XL is sorting the blank row 1 to the bottom of the DBS.

Any ideas much appreciated.

TIA

Steve

 

[Earl Kiosterud]

Steve,

It sounds as if you're selecting once cell and letting it expand the range
to determine the range to sort. Or perhaps you're selecting the columns in
their entirety (like A:G), which would include the empty row 1. If you
define a range (Insert - Name - Define) that does not include row 1, it
won't be sorted.

Range("MyTable").Sort ...etc.

Where are the headings? Row 2? If this hasn't helped, say more about the
layout of the sheet.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Help!

I have a DBS that I created a macro for. The macro displays a blank data

form and after the user inputs, sorts the DBS

on column B, Descending (Column B contains numbers)

The problem lies in that I want a blank column A and blank Row 1, where I

can place buttons to run macros. Whenever I

 

[Steve Simons]

Hi Earl

I am selecting once cell and letting it expand the range. The headings are in row2 as you guessed.

Will naming the range work, as the range will be one record longer each time there is a new record input via the data
form, will the name range automatically cater for the new record? I'll give it a try.



Steve

 

[Steve Simons]

Hi again

I just tested it and the range doesn't cover the oldest record, so the first record drops out of the named range. I
guess I need some VBA code to expand the range?

Steve

 

[Steve Simons]

Hi Earl

I sorted this out with the following code.

Range("B2", Range("J65536").End(xlUp)).Name = "MyRange"

Many thanks for your help - it got me out of a rut on this!

Steve