Mysh1
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 8 articles for 0.302 sec
Brilliant Bernie Thanks!!! Youve been a massive help. "Bernie Deitrick" wrote: > Dave, > > Add a string variable: > > Dim myFName As String > > Then change this: > > Set myB2 = Application.Workbooks.Open(Application.GetOpenFilename) > > to this > > myFName = Application.GetOpenFilename > If myFName = "False" Then Exit Sub > Set myB2 = Application.Workbooks.Open(myFName)     

Group: microsoft.public.excel.misc · Group Profile · Search for Mysh1 in microsoft.public.excel.misc
Author: Dave
Date: Jul 25, 2007 06:36

Thanks again Bernie. One last thing - if the user clicks cancel on the browse screen when looking for myB2 an error comes up. Error 1004 from memory. Is there something we can add to prevent this? Thanks! Dave "Bernie Deitrick" wrote: Dave, See the fixed (and semi-commented) version below. HTH, Bernie MS Excel MVP Sub GetRidOfDupes2() Dim myB1 As
Show full article (10.72Kb) · Show article thread
Bernie, The Macro is not quite working properly. I have uploaded my two workbooks here: http://www.justupit.com/b9f5884e50fb8343170e164c44c57149 I have added your macro in workbook 1. I have highlighted the rows in workbook 1 & 2 that are one offs i.e. the ones that should remain in each workbook. Thanks! Dave "Bernie Deitrick" wrote: > Dave, > > A) Change > > Header     

Group: microsoft.public.excel.misc · Group Profile · Search for Mysh1 in microsoft.public.excel.misc
Author: Dave
Date: Jul 25, 2007 05:42

Hi Bernie, Could you do me a couple of favours with this macro please? A) Please make it so that both column A and B have no headers/title cells. B) Add a description of what each section of the macro does. The reason I am asking for this is so that I can learn more about VBA, so that if need be I can edit sections myself, and so that if other users wish to use this macro there will be
Show full article (9.36Kb) · Show article thread
duh...... it now works perfectly! Really appreciate your help. glenton wrote: > Hi > > Make it > MyCol1 = 11 > MyCol2 = 12 > MyCol3 = 13 > > rather than K,L & M (i.e. the column number, rather than the column label.) > > Regards > -- > Glenton > www.leviqqio.com > Quality financial modelling > > > "shazmar" wrote: > > > Hi, > > > > Many thanks for your help. > > > > I'm     

Group: microsoft.public.excel.misc · Group Profile · Search for Mysh1 in microsoft.public.excel.misc
Author: Dave
Date: Jul 24, 2007 09:04

Hi Make it MyCol1 = 11 MyCol2 = 12 MyCol3 = 13 rather than K,L & M (i.e. the column number, rather than the column label.) Regards -- Glenton www.leviqqio.com Quality financial modelling "shazmar" wrote: Hi, Many thanks for your help. I'm getting an application-defined or object-defined error "1004" at the following Do While MySh1.Cells(MyRow1, MyCol2
Show full article (5.24Kb) · Show article thread
Hi, Many thanks for your help. I'm getting an application-defined or object-defined error "1004" at the following Do While MySh1.Cells(MyRow1, MyCol2) <> "" I've set up as follows - please see the *NOTES* I've put in Sub MyTransfer() Dim MySh1 As Worksheet Dim MySh2 As Worksheet Dim MyCol1 As Integer Dim MyCol2 As Integer Dim MyCol3 As Integer Dim MyRow1 As Integer Dim MyRow2     

Group: microsoft.public.excel.misc · Group Profile · Search for Mysh1 in microsoft.public.excel.misc
Author: Dave
Date: Jul 24, 2007 07:52

Hi I'm still not 100%% sure that I've got it, but please try the following (& as always, pls save before running any macro). In brief what I've done is added a column in Sheet1 which keeps track of whether the information has been transferred to Sheet2 or not. You'll need to set the MyCol1, MyCol2, MyCol3, MyRow1, MyRow2 parameters in the macro (there are comments there to help you do
Show full article (4.13Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Mysh1 in microsoft.public.excel
Author: shazmar
Date: Sep 30, 2006 09:14

Show full article (7.79Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Mysh1 in microsoft.public.excel
Author: glenton
Date: Sep 30, 2006 02:11

Show full article (7.28Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Mysh1 in microsoft.public.excel
Author: shazmar
Date: Sep 29, 2006 11:57

Show full article (6.65Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Mysh1 in microsoft.public.excel
Author: glenton
Date: Sep 29, 2006 02:32

Show full article (5.31Kb) · Show article thread