Creating a range based on values in selected column.

Hi everyone,

I am trying to write a code which will look at a specific column, and save a range of cells of that column which contain "QF". I will then use the retrieved range to insert formulas into next columns but only in rows where the string was detected.

Here is the code I have so far:

Please Login or Register  to view this content.

This code doesnt give any error, it is just not doing anything. Is anyone able to advise on how this needs to be changed?

Kind Regards
Emil

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Please clarify what you are trying to do. Better still upload the workbook and manually add the results you expect.

Just as an aside I can see you have dimmed some variables but not Range0. I guess you don't have Option Explicit at the top of the module otherwise VBA would have bombed out.

Is there really a need for VBA? At first glance a simple Excel IF function could probably achieve what you want.

Thanks for the reply.

This code is a part of a bigger script which will go through 100s of excel spreadsheets to fix existing formulas so I want it to work like this:

1. Go into spreadsheet
2. Check the Column B to find how many rows are relevant. Rows are numbered QF1 QF2 QF3 QF4 etc. All spreadsheets have different amount of rows, I only want to focus on rows that have something in them.
3. Save the range of rows in which QF was found
4. Insert formulas into other columns but only in those relevant rows.

So the bit below should look at Column B and save the starting cell and ending cell:

Please Login or Register  to view this content.

Then I want to use those starting and ending cells to insert a formula into these relevant rows, but in neighboring column. I replaced the actual formula with =2+2 to simplify it, the formula i need works fine when i
specify the range like this:

Please Login or Register  to view this content.

But as I want to insert the formulas only into to the relevant rows in which "QF" was found, I am trying to do that by using the saved start and end cells from the loop above:

Please Login or Register  to view this content.

For some reason I am not able to attach the spreadsheet file?

Hi,

To upload a file use the Go Advanced button. Underneath the post area you'll see a Manage Attachments option. And don't forget to manually add some typical results.

Please Login or Register  to view this content.

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #3 about cross-posting and adjust accordingly...
• Also see, A message to forum cross posters