1. W

    VBA and Headache...

    Oh the headache this is causing... I am sure there is a geniously simple solution to this, but neither me (or google) have discovered it yet. (Google just doesn't understand the question I am asking it seems ) Here is the case: We are a bunch of people using an Excel macro file stored on a...
  2. F

    Flag shifts conflicts on multi-location schedule

    Hi There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back