# Search:

Type: Posts; User: VBAProIWish; Keyword(s):

Page 1 of 6 1

1. ## Thread: Can someone fix this? =IF(A1498=”’,””),VLOOKUP,[Macros.xlsm]Color!\$F\$2:\$J\$500,4,FALSE)

by VBAProIWish
Replies
3
Views
183

### Re: Can someone fix this? =IF(A1498=”’,””),VLOOKUP,[Macros.xlsm]Color!\$F\$2:\$J\$500,4,FALSE)

Sorry for the delay, yes, you are correct, something is missing as it is not working. Any thoughts?
2. ## Thread: Can someone fix this? =IF(A1498=”’,””),VLOOKUP,[Macros.xlsm]Color!\$F\$2:\$J\$500,4,FALSE)

by VBAProIWish
Replies
3
Views
183

### Can someone fix this? =IF(A1498=”’,””),VLOOKUP,[Macros.xlsm]Color!\$F\$2:\$J\$500,4,FALSE)

Hello All,

I'm trying to make this cell say nothing if there is no data in column A. In other words, I don't want the cell to say "N/A" or give me an error. The formula doesn't work and I know...
3. ## Thread: Create a text file for every cell in column A

by VBAProIWish
Replies
4
Views
156

### Re: Create a text file for every cell in column A

Thanks to all!
4. ## Thread: Create a text file for every cell in column A

by VBAProIWish
Replies
4
Views
156

### Create a text file for every cell in column A

Hello All,

I have a workbook with one column (column A) and 400 rows

I would like to create a ".txt" file for every cell.

For example...
If the text in cell A2 says "Orange and Apple", I...
5. ## Thread: Highlight blank cells in the column named "Model" red (not using conditional formatting)

by VBAProIWish
Replies
9
Views
145

### Re: Highlight blank cells in the column named "Model" red (not using conditional formatting)

Yes, I wanted to highlight the cells in the "model" column red, but not all the way down to row 1millionsomething. I want it to stop at the bottommost row of data in the "customer number" column.

...
6. ## Thread: Highlight blank cells in the column named "Model" red (not using conditional formatting)

by VBAProIWish
Replies
9
Views
145

### Re: Highlight blank cells in the column named "Model" red (not using conditional formatting)

Yes, I want to highlight the cells in the "model" column red, but not all the way down to row 1millionsomething. I want it to stop at the bottommost row of data in the "customer number" column.
...
7. ## Thread: Highlight blank cells in the column named "Model" red (not using conditional formatting)

by VBAProIWish
Replies
9
Views
145

### Re: Highlight blank cells in the column named "Model" red (not using conditional formatting)

No, it needs to stop equivalent to the bottommost row of data in the "Customer Number" column.

Thanks
8. ## Thread: Highlight blank cells in the column named "Model" red (not using conditional formatting)

by VBAProIWish
Replies
9
Views
145

### Re: Highlight blank cells in the column named "Model" red (not using conditional formatting)

Row 1, thanks
9. ## Thread: Highlight blank cells in the column named "Model" red (not using conditional formatting)

by VBAProIWish
Replies
9
Views
145

### Re: Highlight blank cells in the column named "Model" red (not using conditional formatting)

The code has to look for the two columns by their names, because the columns will constantly switch position.
I'm looking for the data to stop searching when it is equal to the last row of data in...
10. ## Thread: Highlight blank cells in the column named "Model" red (not using conditional formatting)

by VBAProIWish
Replies
9
Views
145

### Highlight blank cells in the column named "Model" red (not using conditional formatting)

Hello All,

I would like code that highlights blank cells in the column named "Model", red - without using conditional formatting.

I need the search to continue on until it get to the bottommost...
11. ## Thread: Delete a row if one column says "x" or "y" and the other column is blank

by VBAProIWish
Replies
4
Views
212

### Re: Delete a row if one column says "x" or "y" and the other column is blank

That did the trick!

Thanks much!
12. ## Thread: Delete a row if one column says "x" or "y" and the other column is blank

by VBAProIWish
Replies
4
Views
212

### Delete a row if one column says "x" or "y" and the other column is blank

Hello All,

Here's my question...
If the cell in the column named "location" says "Europe" or "Canada", and the cell in the column (in the same row) named "office" is blank, delete the entire...
13. ## Thread: Highlight cells based on criteria

by VBAProIWish
Replies
3
Views
249

### Re: Highlight cells based on criteria

That worked great! Thanks!
14. ## Thread: Highlight cells based on criteria

by VBAProIWish
Replies
3
Views
249

### Highlight cells based on criteria

Hello All,

My first question in awhile here.

So, my question is this...
If the cell in the column named "office" is not blank, and the cell in the column named "Location" does not say...
15. ## Thread: CTRL+End is on row 133 at the end of a macro, but is on row 17 (last row of data) after closing and re-opening the workbook. Why?

by VBAProIWish
Replies
3
Views
148

### Re: CTRL+End is on row 133 at the end of a macro, but is on row 17 (last row of data) after closing and re-opening the workbook. Why?

Wowwwwwwwwwwwwwwwwwwwwwwwwwwww,

I think that is the single best line of code EVER CREATED!

Thanks soooooo muchhhhhh!
16. ## Thread: CTRL+End is on row 133 at the end of a macro, but is on row 17 (last row of data) after closing and re-opening the workbook. Why?

by VBAProIWish
Replies
3
Views
148

### CTRL+End is on row 133 at the end of a macro, but is on row 17 (last row of data) after closing and re-opening the workbook. Why?

Hello All,

I just got some code from some great folks earlier today and I thought my problem was fixed until I re-ran the code again.

Here's what's going on....

I have a sub (called mod0)...
17. ## Thread: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

by VBAProIWish
Replies
11
Views
323

### Re: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

Hi My Aswer is This,

I initially said "A" and "B" for simplicity sake; I just changed the letters and all worked well. Even though the code provided by Jonmo1 worked, I still copied your code and...
18. ## Thread: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

by VBAProIWish
Replies
11
Views
323

### Re: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

Sorry for the confusion everyone. My thread seemed to create a lot of discussion.

So, the whole reason I need to do this is because, initially, I would copy a column, paste it and then do a mail...
19. ## Thread: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

by VBAProIWish
Replies
11
Views
323

### Re: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

Ohhh, let's say column C.

20. ## Thread: Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

by VBAProIWish
Replies
11
Views
323

### Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A

Hello All,

I have this code below that copies Column B, but it starts in cell B2. I need it to copy the title row (Cell B1) as well.

.Range("B2").Copy Destination:=.Range("B2:B" & .Range("A"...
21. ## Thread: Paste Excel Data into Word while leaving Text Form Fields in Place

by VBAProIWish
Replies
3
Views
464

### Re: Paste Excel Data into Word while leaving Text Form Fields in Place

Thanks much Macropod.

I used 4 content controls and they remain intact after the mail merge.

The only disadvantage is that tabbing to each content control seems not possible. It appears that...
22. ## Thread: Paste Excel Data into Word while leaving Text Form Fields in Place

by VBAProIWish
Replies
3
Views
464

### Paste Excel Data into Word while leaving Text Form Fields in Place

Hello All,

I have an Excel workbook that I use and rather than copying and pasting from Excel to a Word form, over 100 cells, I did a Mail Merge in Word.

I thought all was well until I realized...
23. ## Thread: Create a distinct worksheet for each unique value in the column named "Fruit"

by VBAProIWish
Replies
27
Views
1,459

### Re: Create a distinct worksheet for each unique value in the column named "Fruit"

Thanks much for that Fluff!
24. ## Thread: Make this one line of code not error if only two rows

by VBAProIWish
Replies
1
Views
120

### Make this one line of code not error if only two rows

Hello All,

I use this small line of code to auto fill my column past the 2nd row (not including the title row). 99% of the time, this code works perfectly because there are more than 2 rows of...
25. ## Thread: Worksheet tab color chart

by VBAProIWish
Replies
9
Views
822

### Re: Worksheet tab color chart

My Aswer is This..

Yes, that is the easiest way...when not doing it through code of course.