I've modified an existing macro that copies one range to another by pasting
values.  The source range has formulas that use CONCATENATE to build a
formula by looking up values in several cells.  That part works ok, but when
I paste it as values, I need to edit each cell and ...

I have a worksheet with some column in blue color background & when i enter
the data in this worksheet (direction Right when I press the ENTER key) I
would like if the next column is in blue the cursor automaticly jump to the
next column until the cell have no background color.

I am using a macro from Contextures.com to create a new sheet for each rep. I
can run the macro but it only shows data up to column G in each rep new sheet
and the data I am entering on the master spreadsheet goes to column BG. How
can I fix the macro so all of the columns get ...

Row     A         B          C ---Col
1                    SS
2                    DD
3                    EE

I made a user form that opens when you double-click in certain cells. On
the form, you write some values, and then click OK. In the code for the
OK button, how do you know what cell the user double-clicked on?
Gustaf

Hello - I am wondering if anyone could provide me with code that will
re-sort a list, each time a user places a new line at the bottom of
the list.
So, for example, in column A, rows 1-10, I have a list of names, which

On a form I use this to indicate activity
Me.MousePointer = fmMousePointerCustom
Me.MouseIcon = LoadPicture(Application.Path & "\MSN.ico")
then reset using

Can any one guide me or provide some URL or link or doc  to learn the
following concepts. xlup,xldown, xlformulas,xlwhole ,xlnext,xlbycolumns and
xlformulas etc. I am new to excel programming.
Regards,

Having battled the comboboxes i'm now stuck with my scroll bars on my
user form.
I've created a large user form with about 180 controls. It's approx
2500 high so i need a vertical scroll bar. When i set scrollbars to

Excel 2003
I have 50 sales regions on a map with 50 autoshapes for each region on sheet
2.
On sheet 1, there's a column listing of the regions and a corresponding

Hello, Everyone.
I'm having more problems with dates, I'm reading in dates from a
Spreadsheet, and it's swtiching the day and the month around
so the format should be DD/MM/YY (If the order appears Alien it's because

I have data in sheet 1 (see below)
ROW         A           B              C ------col (sheet 1)
   1     CODE     VALUE       CODE_2
   2         SS           10            GGG

I have following data in my sheet. (please see below)
Rows     A            B                C                F
G---col
1           CODE     AMT     CODE_2     CODE          K12----headings

Hello, another day another random problem.
I have just fixed an issue where, I have from someones spreadsheet, two
values.
    A

1. Enters an Excel WorkSheet.
2. Apply an AutoFilter in Column A. It's done. Easy.
3. Apply an AutoFilter in Column C. It can't be done until Column B is
also AutoFilter'd.