Hello All, I am trying to find the minimum number in a column range.
This range contains formulas that return a positive value or a 0. I am
trying to find the minimum number other than 0. I tried to rewrite the
formula so it would return "" other than 0. This works, however it

Sorry about the previous post, i hit Enter and it submitted it...doh
I am getting an error 91:  Object Variable or With Block Not Set on the
following code, but not sure how to correct it.  It seems to be hanging up at:
   rw = SH.Range("A:A").Find(Me.cboMonth.Value, LookIn ...

Have seen other posts on this and seems odd their is no solution.  Have a
column of cells where each cell is a few merged cells.  Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

I'm looking for a faster way to save/restore a worksheet including the
cell formating in an MS Access table. I'm using Windows and Office 2k
I have built a macro to loop on all the cells, put the cell data and
formating in a string with "~" as separator then save it in MS Access ...

Has anyone come across this weird phenomenon?
I have some code in a macro as follows:
With ActiveChart
.HasTitle = True

I am trying to create a XY plotter graph for my experiment using VB 6.
My excel sheet has x1,x2,x3 data in the 1,3,5 columns and y1,y2,y3
data in the 2,4,6 columns to plot my 3 series.The first row has the
parameter names. i recorded a macro in excel and tried using it in Vb6

I am trying to write a code that allows me to select a file and save
it in a different location, and then delete the orginal file. I have
the following code, that does not work, i think i may be over
complicating it. Please Help!

Help with the following.
Example:
A1 = Renewal sale or increase value from Existing Business (5% Commissions)
A2 = New Business from New Customers (7.5% Commissions)

Is it possible to check if a printer (on the network) can handle a certain
page size, for instants A2 size???
I've solved it for now by error handling during setting of page size, by
asking to select an other printer. Problem is that when a second printer is

I open the Control tool Box, selcet the  one to click. I cna edit name etc
but I can never get it to not allow me to  resize it or edit it. what am I
doing wrong? I wnt to add a formula in the VBA part which I have tso that
when it is clicked it will random a number. Would liekth ...

I would like to create a template so that when I Ctrl+N on the
keyboard I receive a new Book with my custom configuration (Zoom,
Color Pallete, Gridlines)
I tried modifying Book1.xlt and resaving it in the same location I

With assistance, I have put together the following code.
The user has a UserForm which they enter values.  On click, the system
searches Column A of the 'HQ Input Log' to see if the month entered in
cboMonth on the UserForm, already exists in Column A.  If it does, the system

I try to put a "sum" formula in a cell:
Sub putformula()
   Dim suma As String
       With Worksheets(1).Activate

via xml i add a tab to a ribbon, say something like:
<tab id="myId1" lable="MyLable">
<group id="gr1">
<button id="myButton1" onAction="MySub1" lable="Test1">

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in.  I run a find and sometimes end up in column O or it could be AA
or X.  I want to be able to select that particular column.
I know that Range(A:A).Select will select column A.  Column(2) ...