Search results for query: *

Yeah - looking to insert a range of 1 column, 29 rows. However, it would allow me to select any cell in the worksheet and when the button is clicked, a "column" with 29 rows is inserted. Sorry for the confusion. Is that a little clearer?

Yes - but it's just giving me the Range(" "," ").Select object. I need it to be any active cell that I select (within the parameters given. I didn't include that code previously). Is there some snytax that I am missing concerning insertion of column with certain amount of rows? Thanks. -Jason

I realize this is pretty basic, but I'm having trouble discovering how to insert a column with 29 rows in it. I have the code that allows me to insert the entire column (Selection.Entirecolumn.Insert) but can't figure out the basic syntax for inserting a column with only 29 rows. Below you will...

Beautiful! It's exactly what I was looking for. I had played around with the GetSaveAsFileName, but couldn't quite understand how best to implement it. Thanks again!

Thanks for all the input. Sorry I'm such a newbie at it all. Soon enough I'll be jumping in threads to help out. But I appreciate the feedback.

Hi - still a novice, but getting it... Creating a macro to Save a workbook in a specific directory. Trying to save myself time because the default directory the open upon SaveAs is the directory where the current workbook is saved, not the directory where I want it saved (and that directory is...

Thanks for the heads up. I browsed the Net and found this solution. I appreciate your code, however, what I am doing is inserting a new column and autofilling certain cells, so I can see your confusion with thinking I was inserting rows. I am posting below the code that I was able to find and...

Thanks - but that's my problem. Since I'm such a newbie at this, I don't know how to script the simple If test. Can you help with that?

I'll give it a shot!

Banging my head against a wall here. I'm new to the VBA world, so trying to get something simple done here. Created a macro button to automatically insert a column with autofill on certain cells. However, I don't want users selecting any cell to insert this column (especially because undo is...