User Profile
bigjim1216
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: need to delete one drive
bigjim1216 Thank you so much. This is what I was looking for. I like the idea of saving my files to the cloud but the headaches are not worth it. I am already saving them to two different external files. I even have it set up in the program to save to this PC and both external drives automatically and that works well. Also thanks for the tip on repairing my files. That will come in handy, but hopefully not as much now that I have unlinked onedrive.6.4KViews0likes0CommentsOne Drive headaches
I have an excel program that I use regularly to track all my financial transactions. Every time I finish updating it with a transaction, I save it my C: drive to an external drive and to a pen drive. Today I open it and one drive is trying to repair it. of course it doesn't say it is trying to repair, but after a while, it says it is unable to do the repair. Fine, so I close it and then open the file in one of the other two locations. Sure enough one drive has somehow gotten into those and is trying to repair and of course when it can't repair (whatever it thinks is wrong with it), it just shuts down. Never says why it was trying to repair it or how I can my program back. I would like to completely disable one drive and delete it from my PC. Any ideas on how I can get my program back and/or delete the annoying one drive?445Views0likes2Commentsneed to delete one drive
I try as hard as I can to not get one drive involved with my excel program, but invariably it somehow gets involved and as soon as it does it destroys my program. I have been running this program daily for over 2 months. When I opened it today, I get a message that it is being repaired. As I try to load my backup, it shows me it is in one drive. Every time it backs something on one drive it damages the program I there any way I can delete one drive from my exel?Solved6.8KViews0likes3CommentsRe: referrall from microsoft support
I got the edit macros problem working. Thanks! I still can't see Developer>Visual Basic. This problem started when Microsoft support was trying to fix the other problem. She had control of my PC and I saw when something she did caused it to go grey, but I didn't catch what she did to cause it. Has to be some kind of setting she changed but I can't seem to find it. Any help here would be appreciated. Thanks again for your help on getting my macros back. Made I live much easier!!! I really appreciate it Bigjim12163.9KViews0likes0CommentsRe: referrall from microsoft support
Interesting. I wonder why I can't see them. They are working, but I cannot get to the code to make any changes. sounds like it's some kind of setting problem, but I still have the problem with my files even though you can see them in the workbook I attached, I still cannot see them in the same workbook on my PC. Strange Thanks for the help by the way. Bigjim4KViews0likes5Commentsreferrall from microsoft support
When I went to Developer then Macros, noneof the macros in my workbook were there. They were still listed under Developer file, but the macro box was empty. I closed this workbook and opened my latest backup to this workbook which had been working but it was alsoSolved4.1KViews0likes8CommentsRe: Excel will not let me record a macro
Thanks for the promt reply. I already did this. I have Macros enabled. All my other macros in this workbook work fine. Just can't record a new one. It does nothing when I click on record macro. Also if I want to just creat a new one, It won't let me click on Create when I open the Macro box. Again all my other macros are there and work fine, just can't do a new one. I thought maybe I had exceeded the limit to how many I could have in a workbook, so I deleted one but that didn't help. Again, Thanks Bigjim14KViews0likes2CommentsExcel will not let me record a macro
I have been working on a workbook that contains several macros that I wrote and some that I recorded. Never had a problem. All of a sudden it will not let me record or create a macro. The workbook is not protected. I select Record a macro. The screen comes up asking for the name. I just use the default, Macro1. But when I hit OK, it does nothing. I can run existing Macros, but I cannot create a new one. Does anyone know what is going on and how I can fix it? thanks, Bigjim14KViews0likes4Commentsselecting a range of cells starting with the ActiveCell
I am using "find" to locate the first empty cell in a column. From that "ActiveCell" I would like to clear the contents of the next 400 cells below it. I set up a for next loop but it is extremely slow. Dim cnt as integer for cnt= 1 to 400 ActiveCell.clear ActiveCell.offset(cnt-1,0) next cnt This works and clears all the cells below the last empty one, but again it's very slow. Is there a way I can refer to the entire range of cells below the first empty one without looping. Something like ActiveCell:ActiveCell.offset(100,0).clear I know this won't work, but was wondering if there is a way I can do it. I'm using Micorsoft365 family. Thanks, JimSolved638Views0likes2CommentsRe: Formula for deleting the contents of a cell
I couldn't get the filter idea to work. I haven't used this before so it was probably just my ignorance. But I really appreciate your help. I'm spending time now trying to learn more about filters because of your suggestion so it will really help me expand my knowledge. Thanks again Jim12KViews0likes0CommentsRe: Formula for deleting the contents of a cell
I was able to do a work around using your suggestion with the zzz and then after the sort, getting rid of them. works good. I really appreciate the help. All of the answers helped. I had not worked with the trim suggestion or filters before, so now I'm working on learning that. Thanks for helping me solve my problem Jim12KViews0likes1CommentRe: Formula for deleting the contents of a cell
I couldn't get the NA() to work but along with Sergei Baklan's reply it got me going the right way and I'm pretty sure I found a solution. Thanks for your help. I really appreciate it. I have another issue I'd like to learn about, but I'll put it into another post. Thanks again, Jim12KViews0likes0CommentsFormula for deleting the contents of a cell
Is there a function that I can use to clear the contents of a cell? I'm using a formula in cell "c2" if(a2="","",b2). Simple formula but the problem I have is if this statement returns a blank cell in col C then it just shows empty, but it's not. For example if I use sort function, it treats this cell as having a blank in it instead of being empty which screws up the sort. I need a way that I can write that "if" statement which will leave cell "c2" as if I had selected it and hit the delete key. My excel is in my Microsoft 365 family if that helps A B C Jim Wisdom Wisdom Barnum Bob Shaw Shaw Mary Franks Franks Hurst Lincoln Mathews Linda Murnan Murnan Ancer Thanks Jim FSolved12KViews0likes9Comments
Groups
Recent Blog Articles
No content to show