How do i reference a dynamic cell range in VBA code

**alice03** · 10-03-2013, 02:27 PM

I am trying to find a way to reference cells in a table using VBA code, when the position of the cells changes with every row inserted in data above it. I have attached a sample of my what I am working with, my code is in ThisWorkbook

Forum Help Sheet.xlsm

Any suggestions are appreciated!!!

**tehneXus** · 10-03-2013, 04:48 PM

Hi,

do you mean the row of "ABC" in column 1 and "DEF" in column 4?

Please check the code in the attached file where "ABC" is searched in column 1 and then the value next to it is compared:
# Forum Help Sheet.xlsm #

**alice03** · 10-04-2013, 12:06 PM

Yes, I that table is going to be filled with variable like ABC and DEF and I need to reference the cell adjacent to each one.

**tehneXus** · 10-04-2013, 01:05 PM

Hi,

did you check the code in the attachment of post #2? Does it work for you?

**alice03** · 10-04-2013, 02:15 PM

I haven't had a chance to..but i will and let you know. Thank you so much for the help!!

**alice03** · 10-07-2013, 08:17 AM

Yes! It works! Thank you!! Do i just write the same code for every item I'm going to have in my table?

**tehneXus** · 10-07-2013, 01:16 PM

The best would be to take the values to search for from the sheet itself (e.g. the values to use are in column X), but with the information you gave in previous posts I cannot see a structure in the worksheet.
Using such code with fixed strings like "ABC" and "DEF" is not flexible as I assume you don't want to adapt the code whenever there is a new string to search for.

So, if possible, could you explain the worksheet and how it should work with the data more precisely?

**alice03** · 10-08-2013, 10:21 AM

Ill try and post a bigger sample so you can see what i am trying to do...i used the code you created on all the variables and something went wrong...and i cant figure out what it is

**alice03** · 10-08-2013, 10:56 AM

SAMPLE.xlsm Here is a bigger sample of what I am trying to accomplish. Again, I really appreciate your time and help.

How do i reference a dynamic cell range in VBA code

LinkBack

Thread Tools

Rate This Thread

Display

How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Re: How do i reference a dynamic cell range in VBA code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to reference a cell within a dynamic range

VBA Dynamic Range - An Indirect Cell Reference

Average a Dynamic Range using the cell before blank cell as the last reference

[SOLVED] Dynamic Range Reference, Varying Size of Range

using a dynamic reference cell to copy a range of cells within a data table

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions