Search:

Type: Posts; User: hrayani; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    67

    Re: VBA Copy Non Contiguous Columns

    Thanks
  2. Replies
    7
    Views
    67

    Re: VBA Copy Non Contiguous Columns

    Thanks Jack - Code is working PERFECT.
  3. Replies
    7
    Views
    67

    Re: VBA Copy Non Contiguous Columns

    Thanks Fluff,

    Your code is working PERFECT 100%


    Sub fluff()
    Dim LrB, LrD As Long 'modified
    Dim LR As Long

    LrB = Range("B" & Rows.Count).End(xlUp).Row
  4. Replies
    7
    Views
    67

    VBA Copy Non Contiguous Columns

    Hello Friends,

    The code is copying two non-contiguous columns.

    How to tell the code to look at last used cell in Columns B & D in said case i.e. from B2 to the last used cell and from D2 to the...
  5. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Thanks Fluff

    All working fine now..... I also figured out why it was giving error on saving the file

    The range references given in the code are cell A1 & F1

    In cell A1 there is value like...
  6. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    run time error 438
    Object does not support this property or method



    setwbk = ActiveWorkbook
  7. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Hi Fluff,

    I tried the solution you provided... Its working fine

    Now its debugging (Run time error 9 - Subscript out of range)


    Windows("Factory Target.xlsx").Activate

    Obviously the...
  8. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Thanks Fluff,

    I don’t have access to my computer right now as I am off from my work.
    But surely tomorrow I will try the solution you provided.

    I will keep you posted

    Take care
  9. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Thanks Fluff - you have always helped me out in my number of threads. I appreciate



    I want to save the file in C:\Backup
  10. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Thanks Joe for your help. I appreciate you are putting in your time to help me out.



    Well, the code is copying some data from a sheet in the current workbook (macro enabled) from which the code...
  11. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Yes sure why not





    Yes
  12. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Hi Fluff,

    I get a msg box BACKUP
  13. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Thanks Joe

    I tried but still facing same problem
    Same error msg & same line debugging
  14. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    The file name or path does not exist.
    The path does exist but the file name does not at it is new file being created


    The file is being used by another program
    Thats not possible coz it is a...
  15. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Debug

    ActiveWorkbook.SaveAs Filename:=fName, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False


    This time its picking literal pars & cells values both - I can see correct name in the msg box...
  16. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Its only picking literal parts - not picking cell values.

    Actual cells are A1 & F1 (both are merged cells) I thought the merging is causing the problem so I removed merging but still same problem...
  17. Replies
    28
    Views
    240

    Re: VBA Code - pick file name from cell value

    Hi Fluff,

    Thanks for the reply... Did you mean something like this


    ActiveWorkbook.SaveAs Filename:="C:\Backup\"MAKE" & Range("A1").value & "MODEL" & Range("B2").Value.xlsx", FileFormat:= _
    ...
  18. Replies
    28
    Views
    240

    VBA Code - pick file name from cell value

    Hello Friends,

    This is part of my macro which I am using.


    Sub makecopy()

    Workbooks.Add
    ChDir "C:\BACKUP"
    ActiveWorkbook.SaveAs Filename:="C:\Backup\Factory Target.xlsx",...
  19. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    same here :(
  20. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    yes the entire column is unlocked.

    In fact I selected whole sheet and unlocked all the cells. Then I selected only those cells which have formulas in there.

    But when I run the code some unlock...
  21. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    Hi Fluff,

    Just noticed one thing.. That every time I run the code some cells gets locked up.. I have only locked cells which have formulas in there



    Sub remove_duplicates_sort()
    ...
  22. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    BINGO........ Works Great.

    Mine code > hundred lines :( (all I am capable of is just recording stuff and finding things on net here & there)

    Your code > 6 lines :)

    Bunch of thanks...... for...
  23. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    Yes, I agree

    Here is what I have come up with and the code does exactly what I want to



    Sub duplicatesremove()


    If Range("C2").Value > 8 Then
  24. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    Hi Fluff,

    I having following two issues

    1) The code is removing duplicates but also deleting formulas from Column C.
    As soon as the duplicates are removed and the cells are shifted up - it...
  25. Replies
    27
    Views
    334

    Re: VBA - Remove Duplicates + Sort Data

    Changes in red


    Sub hrayani()

    Dim i As Long

    For i = 3 To 24 Step 3
    If Cells(2, i) > 8 Then
    With Cells(5, i).Resize(Cells(2, i))
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4