determine

  1. A

    Using VBA to find the cell addresses of a dynamic contigous worksheet range

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I need to determine the cell addresses for the four corners of a selected range on a worksheet. The top left and bottom right are easy since that’s how Excel normally defines a...
  2. A

    Delete one ore more columns within an array in VBA

    Is it possible to pull in a table of data into an array and then delete a specific column of data? Perhaps one or more, if I determine that I only want certain columns of data?:confused: Looking for VBA code to perform this.
  3. P

    Use VBA determine SAP System ID/Client

    Is there a way to determine which SAP environment I am logged on (System ID/Client) using VBA?
  4. M

    VBA to determine next working date excluding holiday List and WeekEnds

    Hello Experts, I have a requirement where i need to update a column in excel with dates thats equal to todays Date + 2 days ahead (Ex: 4-Aug + 2 Days ahead). But the date must not be a weekend (Saturday and Sunday) and also none among the below shown holiday list. Suppose i am running this...
  5. N

    summarizing timesheets

    I'm trying to automate calculation of overtime pay for employees. Employee timesheets are exported from our time system as Excel spreadsheets. They contain two weeks of data. Each day of the week might have multiple time entries. Here's an example of part of a spreadsheet: <tbody> Date...
  6. A

    Run macro after Enter key is pressed

    Hi. I have table with many rows of data, and I'd like to have certain cells copied in the same row when data is entered in a specific column in that row. This is what I have so far: Private Sub worksheet_change(ByVal target As Range) If target.Column = 29 Then Thisrow = target.Row If...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top