tidy

Hi, I'm sure what I'm trying to achieve is easy but my brains not in gear today.... I have a spread sheet which contains 2 rows (E and I) that each have a date stamp in them, what I want to do is calculate if the two dates are on the same day and if so return a value. I firstly tried...

Is there any way to use a Variable instead of "ActiveCell" in the following line: If Not Intersect(ActiveCell, ActiveSheet.ListObjects(CatTable).HeaderRowRange) Is Nothing Then I'm trying to tidy my code up and not use Select so playing around at the moment.

Hi All, I'm trying to tidy up some data into another tab. The source data is infinitely lings I wanted to create a formula to tidy the data into a new sheet.. The data starts on row 5 every time and thenext set of data is every 10 rows thereafter. I’m guessing I need to use the offset, but...

Hi Everyone, I have a number of macros that copy paste change etc and the problem im getting is it leaves the page looking messy for example it might copy and paste data so the copy field is sel;ected so when you then go to this sheet it looks untidy. I've tried a few ideas but it has become...

How can i shorten this code? I think i can shorten the amount of If Else's to just one that does the same thing as what i have got but i dont know how to do this? Take a look. Sub Filterofcolumn() ' ' Filterofcolumn Macro ' Sheets("FolderSort").Select ActiveSheet.Range("A1").Select...