looping through columns to find a value then replace said value with column header

**Sybille** · 10-22-2018, 09:45 AM

Hello Forum,

I have a worksheet with values from column A to AK, and an undetermined number of rows yet.

I need a code to do this : loop through columns B to AK, and, for each cell containing the value 1, then replace 1 with the header of the column in which the cell containing 1 is... (Headers are on the first row).

I know how to do so but only with one column. Can you help me improve my code?

Thank you so much in advance.

Please Login or Register  to view this content.

**Mumps1** · 10-22-2018, 09:59 AM

Try:

Please Login or Register  to view this content.

**Sybille** · 10-22-2018, 10:14 AM

Awesome!

Thank you Mumps1!

Star symbol clicked!

**Mumps1** · 10-22-2018, 10:16 AM

You are very welcome and thanks for the "Rep".

**davsth** · 10-22-2018, 10:21 AM

I think to fully answer the question you may need the below amendment

Please Login or Register  to view this content.

as 10 or 11 etc will be changed by the first bit of code

**Mumps1** · 10-22-2018, 10:38 AM

@davsth: Thank you for your suggestion. I based the code on this line from the original post:

Please Login or Register  to view this content.

which indicates that the value will always be "1".

**Sybille** · 10-22-2018, 10:38 AM

Good point davsth, but I have only "1" in my spreadsheet. The other values are null or text.

Thank you anyway for the hint.

looping through columns to find a value then replace said value with column header

LinkBack

Thread Tools

Rate This Thread

Display

looping through columns to find a value then replace said value with column header

Re: looping through columns to find a value then replace said value with column header

Re: looping through columns to find a value then replace said value with column header

Re: looping through columns to find a value then replace said value with column header

Re: looping through columns to find a value then replace said value with column header

Re: looping through columns to find a value then replace said value with column header

Re: looping through columns to find a value then replace said value with column header

Thread Information

Users Browsing this Thread

Similar Threads

Find multiple column header, filter out other columns, and export data using a macro

Looping 'find' to find a value and replace a value in an adjacent column

Need to find unique name across multiple columns and then list the column header.

Looping with find and replace

looping Find and Replace over two columns

Need a macro to find and replace words in word using excel column 1(find) column (replace)

[SOLVED] Search through columns and find specific text and replace that text with header column

Bookmarks

Bookmarks

Posting Permissions