Teach Yourself Excel Lesson Insert A Column - Insert A Column

I am currently attempting to create a macro that does the following:

-Delete first 6 rows in the spreadsheet
-Delete all of the rows following the last name entry
-Insert a column
-Title the column "Week"
-Allow the user to identify the week number
-Copy that number down the column

While I can record simple macors, the needs of this particular macro are a bit beyond my understanding. Any help with this is greatly appreciated.

Hi all,

Running Windows XP, Excel 2003.

I have written a macro which creates new worksheets, allows the user to enter the name for the sheet and then creates a hyperlink to the new sheet on a menu worksheet.

The hyperlink is inserted in the next empty cell in column B (starting at cell B7) and offset by two rows from the last. I want to only insert the hyperlinks in column B until Row 29. At this point I need any new hyperlinks to be inserted in column D, then column F and so on. How can I do this in code???

Below is the existing code.

Code:

'Add HyperLink on Menu Page to new datasheet
    Range("B7").Select
    Do
        If IsEmpty(ActiveCell) = False Then
        ActiveCell.Offset(2, 0).Select
        End If
        Loop Until IsEmpty(ActiveCell) = True
 
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="'" & AreaName & "'!A1", TextToDisplay:=AreaName

All assistance appreciated
Thanks
Cutter

MS Excel does not let me insert a column. It displays an error message thus-
To prevent possible loss of date, MS Excel cannot shift non-blank cells off
the work sheet.
What should I do to insert a new comumn?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Find "" in column A , where data exists in column B and insert Average into Column A. Stop if no data found in column B.

What I've got so far was easy but the Range will change and my solution wont always work.

Sub find_and_insert()
Range("A1:A420").Select
Range(Selection, Selection.End(xlDown)).Select
Range("A1:A463").Select
Selection.Replace What:="", Replacement:="Average", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

Any help would be greatly appreciated!

Hi all,
I have a spreadsheet (2007, xlsm format) in which I'm trying to add a column. I get the error:

"Excel cannot complete this task with available resources. Choose less data or close other applications".

I don't know how to "choose less data". I'm inserting one column, how much less can I choose?

I'm in Windows 7 64-bit with 6 gigs Ram (4.7 free), and for all intents and purposes, virtually unlimited virtual memory. Excel is the *only* application running.

The sheet is fairly wide, it has data up to column ATM, but only about 600 rows of data; the column I'm adding is around column M.

(Edit)
After looking, there were a string of zeros in one column I hadn't seen starting at row 5000 continuing to the last row. So it was apparently looking at it as a full million or so rows. I was able to then (after clearing the zeros) insert the column--however, the question is still valid, albiet with different parameters: What if I had a million rows--I still want to know why I couldn't insert a column. I have no problem that it might take minutes rather than seconds, but to physically move a million rows--even if they all had valid data--should be physically possible.
(end of edit)

There are formulas is the majority of the cells, but calculation is set to Manual. There are several other worksheets in this file as well...I don't know if that matters. There is an add-in but I don't know if that would affect adding a column.

How can I add a column? I don't care if it takes a long time--I just want to be able to do it.

Thanks for any help,
--Jim

Hello,

Could you have any idea how to do it ?. I was looked anywhere and not
founded any information about that.
I know, i may use the workbook onchange or calculate event, but i must
necessarily get it just at this event moment.
Please, help me !!!

Thx in advance
Grzegorz

Need a macro, please.
I have numbers in column A in every second cell. Alternating cells are blank. I would like to insert numbers from column B into the blank cells of column A.
So data in column A are in rows 1,3,5,7, etc.
Data in clumn B are in rows 2,4,6,8, etc.
Thank you for any help.

Hi,

I have quite a complex macro question to ask (at least in my mind anyway ), but seeing as though people on here like a challenge i thought i'd post it:

First of all see screenshot of my spreadsheet for reference:





What i am trying to do is to create separate macros to do the following: Add a new row after Row 6, and so on, so that it copies the formatting and the formulas of the previous row and that any values generated will be included in the subtotals row (currently in I8, J8 & K8, which will obviously move down as a row is entered each time. Similarly, i need to add a column after Column K, which will 'copy+1' the preceding column [so in my example L2 becomes Apr and L3 becomes =(COUNTIF($B3:$G3,COLUMN(D1)-COLUMN($A1)+1))*$H3], and a subtotal in L8 as well. There are more things i want to do to this but i thought i would share this elephant bit by bit. Props to anyone who can share their tuppence.

Cheers,
pipo