Search results

Hi there, I have a problem at work I am trying to solve, trying to model how we will spend down available funds in a pivotable table. Basically, we have a complex program where we get incremental funding on a regular basis and each funding document will provide an increment for multiple...

Thanks for this! It certainly works in my test file for all the test scenarios. My actual input files range from around 1000 to over 20,000 cells with the data validation applied. I will do some testing with a few of the larger files and see if this code negatively impacts performance (we have...

Ok got it. Sorry about that. Attached is an updated file. I did not alter your code from above. In Sheet2, I have some test inputs that I am copy and pasting into the yellow input cells on Sheet1. When I copy Input Row B, which contains 3 columns of numbers and 4th column as text into E6 on...

Thanks again. This does catch text, but only if the first value in the range they are pasting is text. If, for example, they are pasting across 4 months/columns, and the last one is text but the other 3 are numbers, it allows the copy/paste and thereby overrides the data validation rule. This...

Thank you! Yes, we have had cases where users tried pasting both formulas or non-numerical values. This solution works great for the formulas. What would be the syntax needed to also catch text/non-numerical values?

Hi there! I have to find a solution for a problem we are having with a process at work. We have files that need updated monthly. Users copy and paste from their own excel files into a table in my files. They are supposed to CPV (copy / paste as values) numerical values only, but we invariably...

Hi Pablo, Thanks for the help. However, with the macro in place, I cannot change the selection in the drop down list as the macro runs anytime I click in that cell. Anyone have suggestions? aklewe *happy excel geek*

Narayan - you are genius! I knew it had to be something on my spreadsheet itself causing the problem. I unmerged the cells I had across those columns, and now the code works just fine. THANKS ALL! aklewe *happy excel geek*

Thanks for the help. If I remove 'Range("E3").Activate', I still get the same result when I run the macro...it hides columns A:D as well as E:M. I really am puzzled. aklewe *happy excel geek*

Why it is the seemingly simple tasks can give us the most trouble? I want to run a simple bit of code to hide columns E:M like so... Columns("E:M").Select Range("E3").Activate Selection.EntireColumn.Hidden = True HOWEVER, when I run the above macro, it hides all columns A:M... does...

Good morning! I am so glad to have found this site, its so helpful. I wish to have a macro that runs when the selected value of a data validation list changes in cell B4. It doesnt matter what the value is, just that it changed. The purpose of the macro will be to hide rows where the value...