I have a workbook with a combobox 'CUPrevious' on one of its worksheets, with
change event coded (in the worksheet module) as follows:
Private Sub CUPrevious_Change()
Dim t As String

Anyone know how I can offset from the active cell to the leftmost column a.
I have been trying  Selection.End(x1Left).Select but that doesn't work since
I don't know how many columns to the left column a is each time.  Sometimes
it may be 65 columns to the left, othertimes just a ...

I want to be able to send the contents of a Excel range in an Email.  I do
not want to send it as an attachment, I want it in the body of an Email.
The Excel page contains a logo graphic which is the problem using all the
methods on Ron de Bruin's page, as I understand them.

I've developed a solution that Exports Crystal reports to Excel, then
formats Excel with a few additional things after the export that
Crystal has a hard time doing (e.g. FreezePanes, WrapText, etc).
All is well, except that any additional tweaks that the end user wants

I'm creating an Excel workbook from VB6 that contains exported SQL Server
data.  The workbook can contain more than one sheet - when I'm ready to save
it, how can I reposition to the first sheet?  I've tried the following code,
but when re-opening the workbook it opens to the ...

I have a extern automation system where I create CSV -file to be later
imported into Excel 2003. There is 150 ascii text string variables with
different lengths (but always same) in row and 70 rows. I can add commas ok
by adding ',' between variables.

Can anyone help me? I have a GPS waypoint in decimal, and I need to convert
it to degrees etc. I have a formula I found online, but it doesn't work. I
don't know excel well enough to see where the error is so I'll paste it here.
Either way, if someone knows a formula for doing ...

I have a workbook with several worksheets, i need to do conditional
formatting to column B on each worksheet, does excel conditional
formatting only take up to 3 conditions? cuz my formular is like: if
E2=Y and F2>2, code B2 in blue; if E2=Y and F2<0, code B2 in red,

I have made some changes to a program recently.  Nothing that I haven't done
in the last 7 years.  I am using formulas that are linked to another
worksheet in the same workbook, or a worksheet in a separate workbook.  As I
said, I have done this many times in the past.  However, ...

the comment of a cell next to the right scrollbar isn't visual, because it
pops up to the right.
Do you know a workararound, using the mouseover event or else?
Regards

I searched through the archives and there were a few messages
discussing this but no actual syntax could be found (at least during 2
searches).
Is there any vb equivalent to "Sleep()"?

Is it possible to add a 'floating' label or text box to a worksheet so that,
as the user scrolls down or tabs accross, it remains visible at all times?
Thanks,

I generate monthly excel report with 35 ~ 40 charts.The charts are
distributed in multiple sheets. There is a standard ppt report
template. I manually paste a particular excel chart to particular
slide no. in standard ppt.

I have a data with about 4500 rows and 12 columns. I would like to
copy only the rows where column C haven't "0" value.can someone hep me
with a macro ?
Example

I have a formula in B:B that looks like this
=IF(ISERROR(MATCH(VLOOKUP(A1,I:J,2,FALSE),'$M:$M,0)),"Not Found","")
but
the VLOOKUP is standard. it always looks up adjacent cell in I and