Search results

this seems to have solved it Columns("K:K").Select Selection.Copy Range("K1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False smiler44

This is my final code. Some is duplicated which I know but have decided to leave it as it is Sub levelescalations() Dim subj As String Dim subjj As String Dim re As Object Dim match As Variant Dim td As String ' todays date Dim yd As String '"yesterdays...

thanks Rx. can you go one step further for me please? say I want to copy the visible cells from m? to m100. ? as I don't know the first visible cell after row 1, how do I go about that and then how do I work out what row in k to start pasting? may be the answer to the second part will be clear...

copy and paste after filtering rows I can not believe I cant do this and am sure I have asked before which makes it worse. I have filtered the rows in my spread sheet. In the visible cells in column M after row 1 I have a vlookup formula which returns a value. I want to copy from the next...

thank you, I think I now understand and yes the code does seem to work and not give me an error message. I will test again next week and post back how I get on. thanks again smiler44

sorry arnelgp, I don't understand smiler44

jsmes thank you. I have made a change and now have this line of code vlu = "= VLOOKUP(" & ActiveCell.Address & ",windows(" & bdst & "), Level 2 Escalations!E2:F200,7,FALSE)" but am getting a runtime error 1004 application-defined or object defined error when I use this line of code that...

I am trying to add macro to my personal xlb workbook to run a vlookup between 2 workbooks. the macro looks at workbook 1 the for the information to search for, goes to workbook two to find it and then put the answer into workbook 1. in fact it puts a formula into workbook 1 that does the work...

thanks speakers-86, long did it. I will try to remember for the future glassescase

I am using smith and many other names so I know who's data I am picking up. integer or long, ok i'll try long thanks. I recall reading somewhere there can be a problem using integer. why does dim smith as counter give a problem? thanks again glassescase

what can I declare as a counter? I have dim smith as counter but when I run the code I get an error saying compile error user defined type not defined. what should the dim be? thanks smiler44

Try putting the code after the line that says ActiveSheet.Paste I think the sample code below will change the name of the existing work sheet. Sheet2 being the existing name of the sheet you want to rename, GO being the new name Sheets("Sheet2").Select Sheets("Sheet2").Name = "Go"...

Hi RX, sample code is above. I have a spread sheet with some 20,000 rows and some 80 columns. I only want some data and so using code create a new spread sheet copying across only the columns I want. This still gives me rows of information I do not need. In one of the columns is an ID of...

I found this code at http://stackoverflow.com/questions/10849177/easiest-way-to-loop-through-a-filtered-list-with-vba Option Explicit Sub Sample() Dim rRange As Range, filRange As Range, Rng as Range 'Remove any filters ActiveSheet.AutoFilterMode = False '~~> Set your...

RX thank you for your reply. alas for some reason when I try to open your excel file which looks like an xls file I get cannot open a php file message. I looked at the first link but it's blown my mind I don't understand it. Do I need both the formula and code? I don't understand the...

Ranman256, counting how many times book appears in a single column is exactly what I want to do. Book will not appear in any other column. what is making it beyond me, is counting how many times it appears in that column via only the visible cells. smiler44

I want to know how many times something appears in a column in the visible cells after filtering. for example book appears 12 times in a column, 3 are visible and 9 are hidden. I need the VBA code to return 3. Below is what I have but it includes both hidden and visible instances dim...

thanks gents I will try these suggestions. did not think for one moment it was going to be this difficult smiler44

Thanks Trevor G I've had a read. My functions will be contained within what ever I distribute. you said there are there are several options. can you expand on that and tell me how? Thanks smiler44

I have written some macros that may be distributed to other people. It would be nice to have the macros run from the personal work book. Is there a way I can put macros and modules into their personal work book automatically by running a macro such as an "install" macro contained within the...