I have a file that is stored in a column type fashion, when I transpose the
the worksheet so it will be more database friendly, rows, I end up with
multiple serial numbers in columns to the right rather than down. Example
This is what I have now:

Hello, I have a long-winded question:
I am analyzing data that goes in a sequence.  I have:
Segments 1-15 as the first part of my test
Segments 16-18 as the second part of my test.

I need to save a range in a worksheet as a new worksheet. How can I define a
Saveas to only save the particular range?

Currently, I am working on an Excel template. there is a button created for
user to print the template out.
the problem is after user printed the template, there is a dased line
showing in the spreadsheet. is that possible that the dashed line can be

I'm interested in making a macro that will do my "page set up"
configurations for me.
While I already have made one through manual record, and I've modified parts
of it, I'm left with 3 elements that I do not know the coding for, or if it's

Please help. My new Dell laptop came with Windows Vista. I transferred some
Excel spreadsheets from my Windows XP desktop computer (also a Dell) to my
new laptop. Those spreadsheets were created in Windows XP and are the heart
of my business. Their macros, though voluminous, ran ...

Is there anyway of displaying the current sub or function name that is
running?
Something like:
Sub DisplaySubName()

I have a situation where users have long formulas with external references.  
I need to convert them to absolute.
I tried using this code but it resulted in VALUE# errors
Sub Absolute()

I have a worksheet where employees will be entering in times.  I do
caculations based on these times and I would like a way so if the user enters
inthe time like "10:00pm" that excel will correct it to display "10:00 pm".  
Is there a way to check for this?

hi
I have a slight problem with my code...any help will be appreciated
I have written some codes and use it for vairous workbooks, however, I must
have written something incorrectly as my the orignal code was written for a

Back in 2004 a intern created a Visual Basic program that ran using access
and excel 2003. I am fairly new to Visual Basic and want to implement into
Office 2007. What, if any, are the major differences in code between 2003 and
2007?

Hi, all:
I need to define a cell range which always starts with cell A3 and
have a known number of cells. For example, if I know the number of
cells to be included in this cell range is 5, the cell range will be

I am trying to write a macro to save workbook in different location using the
ip address

I'm new to arrays and although I think I can work most of it out using the
help file, i'm struggling to find out how I add to an array.
e.g.
a=(1,2,3,4)

I am importing information from an AS400 to an Excel spreadsheet.  The date
imports as 20080528.  Is it possible to write a macro that will insert the
date markers (/) at set intervals?
I have never written a macro but do understand the theory behind them.  Any