Dear forums! I'm trying to modify the existing macro by creating new range.
Failure, however, with this and get error 1004
Grateful if you can spot my mistakes
/ Peter
Dear forums! I'm trying to modify the existing macro by creating new range.
Failure, however, with this and get error 1004
Grateful if you can spot my mistakes
/ Peter
Hi,
There are a few macros in there. You'll need to give us some idea which one, what you're trying to change and what you expect to happen.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Sorry Richard, my misstake - keep forgetting that you´re not mind readers...
the working macro is "individuell_lista"
the bad macro is gym
I trying to change the ranges:
Villkor -> VillkorGym
resultat -> resultatGym
namn -> hall
What I exepect is that when I run the micro "gym" then list all games in that gym
Sorry Richard, my misstake - keep forgetting that you´re not mind readers...
the working macro is "individuell_lista"
the bad macro is gym
I trying to change the ranges:
Villkor -> VillkorGym
resultat -> resultatGym
namn -> hall
What I exepect is that when I run the micro "gym" then list all games from the Sheet called Lista in that gym
The error I get (translated from Swedish) "selection field missing or invalid field name"
Hi,
You are attempting to filter stuff to Range("resultat_gym"). The first row of this range A6:J6 does not have any filed names.
Sorry, but I´ve one more question:
If I don´t want to include column D, is that possible, and how?
Hi,
Just leave it out.
The basic rules are
1. Make sure there is a field column label in the first row of your source data
2. Make sure that every field in the first row of your output data exists in the source data. You don't need to include every label only those you want.
3. If you're using an Advanced Data Filter make sure the first cell in a row of the criteria range is a field from the source data.
Common mistakes are blank cells in the source data first row and misspelled column label names in the output data.
Last edited by Richard Buttrey; 05-15-2016 at 03:50 AM.
thanks Richard for your answer!
maybe I'm slow, but do not understand how I can apply your answer in my case:
As you may remember seeing the current macroWhat I would like to do is - in plain English:Please Login or Register to view this content.
copy from range ("matcher") to range ("resultat_gym") columns C, E, F, G, H, I, J
I do not need column D, because it is identical to the range ("hall)
Peter
Last edited by peter_swe; 05-15-2016 at 05:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks