Thanks Dan. I have had similar problems like this before. Now I know why or at least what to look for. Although now I have made it a common practice not to copy and paste.
What if the row you wanna copy doesnt have a number or anything in that row or column but it has a syntax . Is there a way around that to just copy everything else but the syntax? By the way this method does work just having trouble with syntax. So basically copy and paste the formula not the syntax that doesnt have a formula in the cell
Hi Dan , I have watched the visualbasic video about "for next and if then" and have done this spreadsheet using the new knowledge u gave me, but it has small error and I cannot resolve it.
Thanks for the response, I have found the error, a "blank" cell was not really blank. shame there is no code to determine what invisible things are in a cell. can a macro be created to work in any open spreadsheet? ps. Your videos are great and have helped me a great deal.
Hi Rafael, Depending on your internet speed (and how RUclips decides to display a video), your screen may have taken my HD video and displayed it in a lower resolution. Be sure to click the gear icon and switch the video to full 1080 resolution in order to enjoy in HD. Thanks Dan
Thanks ExcelVbaIsFun!!!
Your channel is so helpful and informative. Thank you!
itsakickpushlife Thanks so much itsakickpushlife!!
Hi i want to is there any option that we can disable the complete sheet from manual printing only if we click on the button/shape it will print ?
Thanks Dan. I have had similar problems like this before. Now I know why or at least what to look for. Although now I have made it a common practice not to copy and paste.
Awesome!
This was so helpful, thank you!!
What if the row you wanna copy doesnt have a number or anything in that row or column but it has a syntax . Is there a way around that to just copy everything else but the syntax? By the way this method does work just having trouble with syntax. So basically copy and paste the formula not the syntax that doesnt have a formula in the cell
Hi Dan , I have watched the visualbasic video about "for next and if then" and have done this spreadsheet using the new knowledge u gave me, but it has small error and I cannot resolve it.
optionsupdate What's the area of code with the error?
Thanks for the response, I have found the error, a "blank" cell was not really blank. shame there is no code to determine what invisible things are in a cell. can a macro be created to work in any open spreadsheet?
ps. Your videos are great and have helped me a great deal.
why don't you just make the range dynamic in Excel?
Sorry your video has very poor resolution it doesn't help at all
Hi Rafael, Depending on your internet speed (and how RUclips decides to display a video), your screen may have taken my HD video and displayed it in a lower resolution. Be sure to click the gear icon and switch the video to full 1080 resolution in order to enjoy in HD.
Thanks
Dan