I want to move colC to ColA. I also want colA to not be destroyed. This is
what I'm doing so far. Thanks in advance.
Set objRange = objWorksheet.Range("C1").EntireColumn
objRange.Copy

I would like to take a value in a cell (B3) and perform the following
calculation and record in cell (B4)
If B3>120, then subtract 20 and multiply the result by 1.08.
If  B3<=120 then multiply B3 by 1.08.

We have a basic workbook that managers use to record comments (good or bad)
about other managers.  When an entry is made, the manager's name is entered
in column A, the date in column B and the comment in column C.  The workbook
is available to all managers.  However, when a ...

Is it possible in VBA to make a sub that formats a cell?
I would like to have 0.000005 displayed as 5.00 ppm but I want the value to
remain unchanged.
I guess I am asking how Excel makes .05 display as 5%

Is there any way of getting the Date Created & Last Modified Dates for an
Excel file so that I can create a summary report of time spent on on a file?

When I interactively use the Data->Subtotals function, it creates the
subtotal lines and grand total line at the bottom, correctly per my
grouping column and subtotal columns.  It also puts in "range bars" on
the left hand side that allows easy navigation, collapsing, expansion

Is there a way to run a macro on exiting a cell. For example if I answer Yes
in cell A4, then I would like it to automatically go to A10 on exiting A4.

I am trying to write an Access memo field into an Excel TextBox from the
drawing toolbar.   For some reason if the memo field is over 255 characters
nothing will appear.  I know a textbox will hold more than 255 characters.  I
am trying to use 1 Excel template file to create ...

I want to write a sub to do the following when a user closes the worksheet:
1) Using a message box, check if data has been entered into cell named
"Date".  If the user answers yes, save the file.  If the user answers no,
goto the "Date" cell.

when i step thru a code in a module, & it runs into an error, it lets
me choose a button "Debug."  then i can go into the code & try several
different things without exiting the code (helpful for a learn-as-you-
go person such as myself).

I don't want to hard code the path and file name.  I want to make it dynamic.
This is what I have so far but it fails.  Any ideas?  Thanks a lot, Darren
Sub import_cmsies_in_trans()
Dim vInv_file As Variant

I have to copy and paste text data from a web-based report into an Excel
spreadsheet. I then clean up the spreadsheet data by several macros and
transfer it to MS Access for further processing there. What I'd like to do is
automate and simiplify the process as much as possible. I ...

I need to insert a row above a subtotal row
[=SUBTOTAL(9,C$1:INDIRECT(CELL("address",OFFSET(C11,-1,0))))]
rows 1 - 10 contain data
row 11 = subtotal row 1-10

How do I make the format of a calculated field equal white if the value is
zero. or the same color as the cell background?

My XL spreadsheet has multiple pages.  I need to be able to extract single
sheets as tab-delimited text withOUT opening excel.  Typically this will be
done via command line in a linux env.
I believe this can be done, can anyone point me in the right direction