VBA: Loop through cells in matrix and return column- and row headers

**Søren Larsen** · 06-24-2012, 02:48 PM

I'm struggling with a piece of code I'm working on.

I want to loop through each cell of one table and compare their column headers (text) and row headers (dates) with the contents of another table.

Currently my code looks like this:

Please Login or Register  to view this content.

Any help and suggestions are much appreciated!

**StevenM** · 06-24-2012, 03:21 PM

I don't know what your code does, but cDummy and c1Historik should be declared to be As Range, and then they should be treated as a range.

Assuming that "rDummy" is a name of a range, then:

Please Login or Register  to view this content.

cDummy is a one-cell Range inside Range("rDummy"), as such it acts like a Range variable.

Please Login or Register  to view this content.

This will return the value of the first cell with data to the left of cDummy.Address.

**Søren Larsen** · 06-25-2012, 08:43 AM

Thanks; I see where I got it wrong! For good measure; here is the final and working code:

Please Login or Register  to view this content.

VBA: Loop through cells in matrix and return column- and row headers

LinkBack

Thread Tools

Rate This Thread

Display

VBA: Loop through cells in matrix and return column- and row headers

Re: VBA: Loop through cells in matrix and return column- and row headers

Re: VBA: Loop through cells in matrix and return column- and row headers

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions