-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
matchheaders
-
M
Run time error Method Value of Object Range Failed -2147417848 (80010108)
Hi All, I am having a weird problem that each time it prints the data - it gives the error message Run time error Method Value of Object Range Failed -2147417848 (80010108) When i debug it and and continue with the code by pressing F8 - It works fine and prints the data however it keeps...- mahmed1
- Thread
- dim end lcol long matchheaders
- Replies: 0
- Forum: Excel Questions
-
M
Speed Code & amend to shorten/neaten code
Hi All This code works fine - i think how can i amend this code to make it shorter/neater and speed it up All im doing with the code is seperating each line by a question (currently all questions are across) Hoping someone can help me Many thanks Sub transposeme() Dim RawDatash As...- mahmed1
- Thread
- dim lcol matchheaders outputsh.cellsoutputlr ws.cellsi
- Replies: 2
- Forum: Excel Questions
-
M
Match VBa error
Hi all I have been having issues with my match function if there isnt a match found. I had initially had worksheetfunction.match but read that i need to change to application.match but im still getting a type mismatch error - where am i going wrong? MatchHeaders =...- mahmed1
- Thread
- 12.value found match matchheaders outputsh.cellsoutputlr
- Replies: 4
- Forum: Excel Questions
