+ Reply to Thread
Results 1 to 3 of 3

Simply Adding a Column in a macro/worksheet?

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    4

    Simply Adding a Column in a macro/worksheet?

    Simply Adding a Column in a macro/worksheet?


    Hi my name is Chris- im not the hot on excel macros ill admit so here goes:

    I have a worksheet that has a macro formed to calculate pipe quantities but i want to extend the amount of cells eg: a1,a2,a3 etc-- BUT when i use my logic from standard excel to simply insert column nothing happens- no columns are added- its as though its locked and probably in the macro script or something i need to state a range eg: a1 to z8 but i have no idea hoe to do this-- if anyone would be so kind i can forward my excel file and see what you think is the answer? Id be ever so grateful! And you of course would so cool in my books and totally make my day-- ive been going round in circles for about an hour! lol
    ~Help lol

    Thanks much
    Chris W

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Simply Adding a Column in a macro/worksheet?

    By "Adding a column", you apparently mean "inserting a column." Right?

    Post an example of your workbook and the macro code and someone will take a look.

  3. #3
    Registered User
    Join Date
    08-06-2009
    Location
    Derby, England
    MS-Off Ver
    Excel 2003; Excel 2007
    Posts
    20

    Re: Simply Adding a Column in a macro/worksheet?

    Check:
    Tools --> Protection

    The sheet may be protected (which you should be able to turn off) which may be stopping you inserting a row or column

    If not post up your sheet for us to look at

    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1