Search results

thanks for the replies I think this is solved smiler44

how reliable would this code be? this seemed to work and I'm surprised so I do ask if this would be reliable on a filtered column Sub Macro1() Dim lst As String Dim lr As String ActiveSheet.Range("a2").Select ' row to start If ActiveCell.Offset(1, 0) <> "" Then...

borebende, thanks for the reply. Recording a macro alas will always get the exact range I select but may range will vary. I need to work out the range. mmm let me go try something smiler44

For excel 2007 and 2010 I want to filter a spread sheet and copy the data that is visible. I don't know the range of the visible cells, how do I get the range of the visible cells? I think if I just copy visible cells, it copies all blank cells that are outside of my filtered range...

Brian my goodness no need to apologise your always very helpful. whenever I see your user name on one of my posts I know the issue will be resolved. smiler44

no worries. all sorted and macro is working fine. after a couple of hours I found some columns were hidden in the original work book :banghead: thank you everyone particularly Brian smiler44

Brian, no, I'm stumped. I cant work this out For r2 = 1 To lrws2 'rescan For r1 = 2 To lrws1 If ws1.Cells(r1, 2) = ws2.Cells(r2, 1) Then ws1.Rows(r1).EntireRow.Hidden = False Exit For End If Next r1 Next r2 I thought: r2 was column 2 on sheet 1 r1 was column1 on sheet 2...

Brian, thank you. Not sloppy at all I will keep macro 1 an use it but was just checking it was not required in conjunction with macro2. could you help me a bit more? agh, hang on, I may have it, let me go try and I'll be back smiler44

gggrrrr typed a reply but it timed out and I lost the post. Brian, thank you. I think I understand but can I check. macro2 will display on sheet1 1 instance of a word in column B if that word is found on sheet2 column A. Do I need macro 1. Thank you for taking the time tom put this...

sorry I'm lost. smiler44

I did want to automate but accidently finding this did the job...of sorts. when I click away from excel the drop down list of the filter closes so it was not quite the solution I thought it was smiler44

thank you for the replies. By accident I found an easy way. Not a way that I had expected but never the less will do what I need ok, I use a macro to filter my spread sheet to show only the rows that contain pen, car, boat etc in column whatever. could be about 25 criteria's and of course be...

namliam, thank you but sorry I don't follow how to and I need to add a twist to me request. The spread sheet I want to filter is a new spread sheet that I download from a server. Anything I want to do I think needs to be done via the personal workbook. what should the two formulas look...

I have a spread sheet with a few thousand rows of data. I want to filter using the data in column L that matches for example pen, car, boat. I do not however want every row but just any one row that has pen in column L, or has car or boat in column L. So even if there are 10 rows with pen in...

I think I have solved this. Excel 2010 just does not like the location in the code where Set searchItems = searchFolder.Items is. I have moved it to a new location and it seems to be working. don't quite understand why excel 2007 was happy with the location yest 2010 was not smiler44

This macro is an excel 2007 macro but fails to run in excel 2010. stepping through the code it fails at Set searchItems = searchFolder.Items I fear it may be line by line I ask for the excel 2010 equivalent code Sub moveemail() ' In the Visual Basic Editor (VBE)...

fantastic, with your help this now works in it's test state and I can see no reason for it not to work when used in anger. I'm chuffed but it's not code I have written and truth be known, I don't understand it. that you RX_ and BigHappyDaddy for your help. Any more questions I do a new...

BigHappyDaddy, thank you very much. It has indeed overcome the user defined problem. Now it does not like : Set NS = Application.GetNamespace("MAPI") this gives Run time error 438 object does not support this property or method so I changed it to this, but does it do the same thing...

I am trying to move emails from an inbox to different sub folders and count up the number of unread emails in the inbox and sub folders. I need to check the subject line for some information such as abcd123456. if this is found I need to go off and do something. I have the excel code to...

sorry RX_ that has gone right over my head smiler44