cell ranges

  1. B

    Check Manually Inputted Text in Cell Range Contains Text from Several Validation Dropdown Lists

    I have manual inputted text strings in cell ranges: B104:B125 B132:B175 There are validation dropdown Lists located in the following ranges: B200:B212 D200:D212 B221:B231 D221:D231 The drop down lists could be 1 text string in 1 cell or 1 text string in every cell in the specified ranges...
  2. P

    Dynamic Ranges (without range address unavailable) inside a Formula

    Hey Guys! I immensely need your help for the below scenario. I am trying to find a way to address range in a formula. The problem is that, the range is created dynamically. Please refer below image further. Here I have 2 tables say Table 1 & Table 2, these tables are snippets of my actual...
    • predzer
    • Thread
    • cell ranges dynamic formula excel vba arrays named range
    • Replies: 13
    • Forum: Excel Questions
  3. C

    Modifying a formula from VBA

    I'm very new to VBA and never really used Excel for calculations. That said, I've managed to get some VBA scripting working in a workbook, with the help of a few people from this forum...
  4. M

    Updating cell ranges Dynamically

    Hi All. I am working with an excel document that will be updated periodically, with additional information being input from time to time, which will expand the amount of cells in the current database. I have a pivot table which needs to be updated, and needs to include all the information...
  5. B

    VBA for vlookup with dynamic range

    Hi I am trying to write a code with vlookup. The purpose of the code is to reference a data set in another sheet using vlookup and show the corresponding values. The data sets may may be varying in sizes. So i want the vlookup to go to the last cell possible with the data. I have tried these...
  6. L

    Using Cell and Column Number references inside Range

    I am wondering if this syntax is ok or what I can do to change it. I am getting a Run-time error 1004: Application-defined or object-defined error with this line when I run my code: TestInfo_CopyArray1(i, 1) = ThisWorkbook.Worksheets("Summary").Range(Cells(13 + i, 4)) I have definined my Array...
  7. V

    Last cell in selected range

    This issue is widely discussed in the Internet, but for simplistic cases - when we have a rectangular Selection or when it goes about last filled in cell on a Worksheet. My question is different: Suppose we selected with Ctrl single cells: C5;A1;B3 - I need to get C5 as first cell then and B3...
  8. L

    Conditional Formatting according to colour of other cell

    Is it possiable to conditional format an area of cells based on whether or not there is a red shading cell in that row, i.e. for cells A1:A15 if there is a red shaded cell in A16:A25 then the entire of A1:A15 row needs to be shaded red as well?? Many thanks
    • lhk201
    • Thread
    • cell ranges colour cell conditional formating
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top