conflict

  1. S

    Method Range of Object Worksheet Failed error

    I am receiving the method range of object worksheet failed error on the line below: G() = PBK.Range(Cells(2, 1), Cells(N, 1)) G is a variant, PBK is "Set PBK = Workbooks("A_LA_CARTE.xls").Sheets("Sheet1")", and N is an integer variable I am not sure why the range method used to select the...
  2. O

    Schedule Conflict code

    Hi all! I am not really sure what to call what I am looking for, so if this has been asked before I apologize. I am making a schedule each month and I want to make sure I dont schedule people in more than one department. Is there a function that will allow me to type in a name on one sheet and...
  3. K

    IF Function with multiple criteria

    Hello, I am trying to perform an IF function with multiple criteria. I'll explain what I'm trying to do first and then my formula is at the end. There are 3 columns: Check Mark, Formula, Activity (in A, B & C) In my example, imagine the "1" to be a check mark to do the activity in column C. If...
  4. M

    conflict in data of columns

    Hi, I am a herbal medicine practioner, I made a excel program to help me in my trade. I need some help from excel vba masters that how can I do vba coding for following: 1) Sheet1 col A and B <colgroup><col><col></colgroup><tbody> Medicine Tmp No Mohrak 1 Molyen 5 Shadeed 1 Molyen 1...
  5. B

    Shared Workbook Functionality - VBA code to make sure conflicts don't happen.

    I am building a workbook for several users to enter data. There are a number of fields for each record, and the users may not know there is a conflicting save point (created by another user) until after they've spent a decent amount of time in the workbook. Is it possible to have a VBA code...
  6. B

    conflict in conditional formatting

    Hi, I hope someone can assist with my predicament! I have an Excel spreadsheet (2010) which has two tabs, one a list of dates and tasks, the 2nd sheet is a calendar. When a date is entered into the list, depending on the type of task I have got it to conditionally format the appropriate date...
  7. B

    CONFLICT resolution in a shared workbook...

    Hi, i've just started a new job today and i introduced shared workbooks to the office but I have a problem which has caused me to have some egg on my face.. (:S) I have a shared workbook on a network and when there is a conflict, Excel doesn't ask my permission. The shared workbook settings...
  8. already

    macro conflict when saving

    Hello When opening my file I went to full screen (sub workbook_open) with a macro and when I close my file I went back to a normal screen also with a macro (BeforeClose) code = Application.DisplayFullScreen = False or True When closing the file even when I change nothing in my file the...
  9. E

    Shared Workbook & User Form Controls

    Hello! I am attempting to create a shared workbook with 3 different "types" of users, with multiple users of each type. Every user will have his or her own tab in which to operate. However, I want to create a User Form object for each type where users will be able to input and update data. I...
  10. I

    Version Conflict With Find/Replace?

    Worksheets("Main").Range("C3:GT69").Select Selection.Replace What:="X", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False I am working with version 03, and I do not have any issues with the above code. I...
  11. G

    Shared Workbook Conflict Issue

    Hi Folks, I have a userform which multiple user will be accessing to enter data, this data will then be saved on another workbook, I’ll call this file "log" this workbook is shared so that more than one user can access it at the one time. On the user form I’m using the last row code to find...

Some videos you may like

This Week's Hot Topics

Top