I have a number in a cell and i wantn to insert that amount of rows on sheets from A:H

**swade730** · 08-08-2015, 04:18 PM

Hi

Please Login or Register  to view this content.

In cell I1 I have a value, lets say 7 right

So I want to use that to insert (from colum A to H) 7 rows!

Im fiddiling with the codes above but can't quite seem to come to a solution

From column

**swade730** · 08-08-2015, 04:38 PM

I figured this out

'

Please Login or Register  to view this content.

my brain hurts-

marking solved

**FDibbins** · 08-08-2015, 05:02 PM

Your request is confusing?

Your title asks for both rows AND columns

insert that amount of rows on sheets from A:H

Your question asks for columns AND rows...

I want to use that to insert (from colum A to H) 7 rows!

Your macro is working on rows

).EntireRow.Insert

Which 1 is it?

I have a number in a cell and i wantn to insert that amount of rows on sheets from A:H

LinkBack

Thread Tools

Rate This Thread

Display

I have a number in a cell and i wantn to insert that amount of rows on sheets from A:H

Re: I have a number in a cell and i wantn to insert that amount of rows on sheets from A:H

Re: I have a number in a cell and i wantn to insert that amount of rows on sheets from A:H

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to insert number of rows based on value of a Cell

[SOLVED] Insert number of rows with data to new sheets based on values in cells

[SOLVED] insert rows based on number in cell and copy the data down into the new rows

[SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows

[SOLVED] insert an x number of rows according to data in a cell

Insert a number of rows based on the value in a cell

[SOLVED] Insert cell data every given amount of rows

Bookmarks

Bookmarks

Posting Permissions