Below is a sample of worksheet which starts at Column A and Row 2.
The macro converts columns " H " and " I " into Maidenhead data in column " J "
Please Login or Register to view this content.
The macro below is failing at " With Sheets(1) "
Please Login or Register to view this content.
The actual worksheet is something like 5000 rows, and 30 columns, of data .
Last edited by Potholes; 05-16-2019 at 01:21 AM.
And what does Maidenhead mean please? Not everybody is supposed to understand technical terms/jargon.
Good afternoon
Normally GPS Co-ordinates are shown as
Latitude longitude
-35.378932 148.952144
The Globe is divided into square boxes and
Please Login or Register to view this content.
Converts GPS Co-Ords into what is called Maidenhead it is a term used in the Millitary and in Amateur Radio to indicate the location of someone or something, depending on how many characters & digits set the accuracy in this case the item is within a 100 metre radius. QG62MHGN
Peter
Peter - you know the form by now. Please attach a sample workbook to aid your helpers. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Good evening Alli
Part 1 of this thread has the "Part Full Content.xlsm " file
According to your example file.
Also remember that seguence is 2 char - 2 dig - 2 char - 2 dig - 2 char...
Your example has 2 pairs of char besides each other which isn't correct.
Please Login or Register to view this content.
Last edited by bakerman2; 05-16-2019 at 04:45 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you For the correction
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Good morning all
I have marked this thread as UNSOLVED due to adjustments I have made to the main file
I have attached my file "Potholes_21_May.xlsm",
Since the original file was worked on I have added the full database into a sheet called "Names"
it is this sheet I would like the Macro "Maiden" to run on the " Names " page, thus converting the GPS co-ordinates in columns "H2" and "I2" into Column "J"
Below is part of the "Names" sheet to illustrate just what I am trying to achieve.Please Login or Register to view this content.
Any questions feel free to ask me.Please Login or Register to view this content.
Regards
Peter
Last edited by Potholes; 05-21-2019 at 02:41 AM.
Seems to be posting fine to me?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The number 13 in With Sheets(13) is the SheetCodeName (the name NOT between brackets in the left upper code pane). Also we perform a test to see if both columns hold a valid number.
Please Login or Register to view this content.
Last edited by bakerman2; 05-21-2019 at 07:36 AM.
Attached is my working file
On the "Names " Sheet is the Button for the Maidenhead macro I have entered the code as supplied tonight but it has not helped
Any assistance would be appreciated
Peter
Put all codes together.
Hi all and anyone reading this thread
Attached is my TEST working sheet "Potholes_Final_2.xlms
On the NAMES page I have two command buttons, one is for the Maidenhead macro, the second is to carry out a complicated COPY macro.
I added the data to the maidenhead that was sent to me last night but it has not helped. The code for that macro is below.
...............................................................................................Please Login or Register to view this content.
Below is a section of the VK1 Sheet, which is blank now
...........................................................................Please Login or Register to view this content.
The copy code that I would like is to go to the " Names " sheet go to column " A " drill down looking for any call sign starting with VK1R## (ONLY )
then COPY the rows of data from column " A through to Q " a sample is below (I have hidden some rows ), then paste that data to Cell A2 on the VK1 page,
then go back to the Names sheet go to column " A " drill down looking for any call sign starting with VK2R## (ONLY ) then paste that data to Cell A2 on the VK2
page, and do the rest of all call signs so basically you will do VK1R## to VK0R##.
Below is the copy code that was sent to me but all that does is leave something like a drop down box on top of each row, and does not copy any data as I need .
Please Login or Register to view this content.
This is a sample of the VK1 Data with some rows hidden for now
Please Login or Register to view this content.
If anyone can assist please, any problems understanding what I am trying to achieve please drop me a note.
Regards
Peter
Last edited by Potholes; 05-22-2019 at 01:05 AM.
Did you even try the file I sent in Post#13 ?
Good afternoon Sire
Sorry for the confusion, I did miss your file, I have downloaded yours and attached a file named " Bakerman.xlsm ", the code
works only ONCE so if I have to update the Whole of the data on the Names page and run the copy again it does not copy over anything
I have moved everything on all of the VK sheets to confirm that it is copying over and nothing is happening.
Maidenhead AOK
Pete
PS
When it copied the data over it also copied Row A1 so it shows up twice..
That sounds like the data is filtered. Try this:Below is the copy code that was sent to me but all that does is leave something like a drop down box on top of each row, and does not copy any data as I need
Note the macro appends the data to the next available row - it doesn't overwrite.Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Good Evening
Many Many thanks for your help.
Peter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks