So what's the problem? When you change column C then the VLOOKUP should update, except there is nothing to lookup for B
Posts by royUK
-
-
Which cell contains the formula? It cannot be C.
-
Pleased to help.
Post back if you need further help.
Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.
-
SenKeys can be tricky.
What exactly are you trying to copy.
-
I'm surprised you want to delete archived items, what happens if you have a query relating to one of these items?
Try this
-
You never mentioned MergedCells. MergedCells will generally cause problems ans should be avoided.
-
Quote
Hi Roy - no, if I could, I'd paste special values the entire sheet. Thanks for looking into this.
If you select all the cells, hidden or not, then copy and paste values then all formulas will be overwritten.
-
Quote
Hi Roy - no, if I could, I'd paste special values the entire sheet. Thanks for looking into this.
If you select all the cells, hidden or not, then copy and paste values then all formulas will be overwritten.
-
Good luck!
-
Attach an example of the workbook
-
At least take the time to explain what you want in the question, not rely on people downloading the file.
-
You don't need to use the file extension in the filename when declaring the file type.
Why are you saving as .xls?
-
You need to attach an example of your workbook, after reading the Forum Rules.
-
Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post
All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.
How to use code tags
Just highlight all of the code and press the <> in the post menu above button to add the code tags.
Thanks.
-
There's not enough information to answer. Maybe an example of the workbook would help.
-
Why do you even need VBA for this?
What is SUM?
-
Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post
All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.
How to use code tags
Just highlight all of the code and press the <> in the post menu above button to add the code tags.
Thanks.
-
This code (Range("F7:F100") will only work on the active sheet because you do not explicitly use a sheet.
Probably you can improve the code by not looping as well. Attach an example of your WorkBook.
-
Without seeing an example of your worksheet it's hard to help. You say Tables won't help, but why?
-
You don't lose anything. What are you trying?
Quotethe first thing i try are macros...
all macros i try give errors, and being a basic user i have no idea where and what i should have to change in vba...
Do you mean you are trying code to convert to Tables?
Converting to Tables won't work if you have completely empty rows or columns in the data, but if you have then Excel's Database features won't work either.