![]() FrameProgress.Caption = Format(PctDone, "0%") 'delete the blank row at the end (artifact from wunderground) ![]() Range(Selection, Selection.End(xlDown)).Select Sub Test()' The UserForm1_Activate sub calls Main Again any help here would be much appreciated. If there was a way to trim off the rest of that data that would be awesome too.Īnyways here is the code. One other thing, Really all I need is Temperature, Wind Direction, Wind Direction Degrees, Wind Speed and Wind Speed Gust, and Date. If anyone also has any ideas on trimming this code or making it more efficient that would also be greatly appreciated. ![]() I highlighted some areas of the code that may be wrong/might need some attention. For the most part I have what I need its more of a formatting issue now so that I can make use of this data. Would someone mind looking over my code and give me some pointers on what is going wrong here. The Third problem is that I am trying to move the data from the last column over to column A but there is clearly problems with that also. I would like the data to be written every row obviously.ģ. The second problem, which may be because of the page break, is that it writes the weather data to every other row. ![]() I am unable to get rid of the last page break " " or "html junk" in the header Cell O5 labeled DateUTCĢ. This is the code I have so far and I have three problems.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |