ClubMembers.docx
Hi all. I'm desperate for some help. I hope the attached file works cos trying to explain my problem with text would be a nightmare. Unfortunately, VBA and Macro seen to be grayed out so cant do it that way. Any help would be great.
ClubMembers.docx
Hi all. I'm desperate for some help. I hope the attached file works cos trying to explain my problem with text would be a nightmare. Unfortunately, VBA and Macro seen to be grayed out so cant do it that way. Any help would be great.
Hi randall,
Will conditional formatting work for you? See http://www.automateexcel.com/2009/02...al-formatting/ to tag all numbers greater than 200 or your cut value.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
With conditional formatting, i believe that you can only change the format of a cell, like its color but not its contents, please correct me if i am wrong.
Without vba you can only do what you want by using a formula in the cells E4:E12, which you will be overtyping when you manally change them back to Y, so the formula will not be there to reuse the following year.
If vba is not available then I'm guessing you have a trial version of excel that came preinstalled in your pc / laptop?
I have office home and student 2010 that i purchased myself. Maybe i can use the CD to add program features, if it's on the CD that it. If so What VBA code would i use to solve my problem. If my CD does not have VBA, where can i get it.
Last edited by randall78; 06-25-2012 at 02:09 PM.
I think it should be on your cd, but don't have that specific version to verify that.
code would be something on the lines of
** Note that the code is untested. I have been having system stability issues over the last couple of days, and trying to test the code resulted in an error which I think is related to those issues as I can't see any other reason for it.Public runonce As Boolean Private Sub Worksheet_Calculate() If runonce Then Exit Sub With Application .EnableEvents = False .Calculation = xlCalculationManual .ScreenUpdating = False If Range("H1").Value > 200 Then If Range("I1").Value <> "N" Then Range("E4:E12,I1").Value = "N" Else Range("I1").ClearContents End If .EnableEvents = True .Calculation = xlCalculationAutomatic .ScreenUpdating = True End With runonce = True End Sub
MarvinP could you verify? Runtime error 28, out of stack space is being returned at the switch to manual calculation.
Hi,
Add a Watch of runonce and see if it ever goes back to false so your code is run more than once. Also add a breakpoint on your "If runonce then..." line and see if it is doing what you expect. I expect you are running this code so many times it is filling the stack and you get an error. You can do a memory check to see if you think it is bad memory.
Thanks ever so much for your quick reply and help, as soon as I have VBA up and running I look forward to testing the code. I will keep you informed.
Ok, thanks for your help. I guess i should of mentioned the i am a novice when it comes to using VBA, in fact, i have never used it before. i have tried running that code and i get the error "invalid attribute in sub or function" and the word public on the first line of code is highlighted.
Sounds like you have put the code in the wrong place. Did you add it to the worksheet code module?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks