LinkBack URL
About LinkBacks
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 iconbelow 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.
Thank you for our answer Richard :-)Originally Posted by Richard Buttrey
The problem was not only that, but also that the range should start from column C
Once again many thanks for your time, dedication and help. Every time I get a little better at excel macro
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks