How to create a custom function that creates a list like this {1,2,3,4,5,6,7,...}

**keenlam** · 11-14-2012, 01:26 AM

Hi everyone,
I'm new to the forum. Also new to Excel macros and VBA stuff.
Due to a project at work, I need to dig into this for the very first time.

My problem is described as follows:
Input: user specifies a column range which serves as the only argument for the function
For example: E11:E20
The function extracts the number of the rows this column range has, in this case, 10 rows.
Output: The function creates a row array with 10 elements like this {1,2,3,4,5,6,7,8,9,10}

I know the function ROW in Excel can do this in a similar way given that I choose the appropriate cell range.

Sorry for my English. Would highly appreciate any help. Thank you.

**kvsrinivasamurthy** · 11-14-2012, 02:21 AM

Pl see the attached file with UDF.

**NickyC** · 11-14-2012, 02:23 AM

hi
are you trying to transpose the data? if so, why not use the transpose command?

**keenlam** · 11-14-2012, 02:47 AM

Thanks, guys. I see what I can learn from what you've suggested.

How to create a custom function that creates a list like this {1,2,3,4,5,6,7,...}

LinkBack

Thread Tools

Rate This Thread

Display

How to create a custom function that creates a list like this {1,2,3,4,5,6,7,...}

Re: How to create a custom function that creates a list like this {1,2,3,4,5,6,7,...}

Re: How to create a custom function that creates a list like this {1,2,3,4,5,6,7,...}

Re: How to create a custom function that creates a list like this {1,2,3,4,5,6,7,...}

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions