.cellsemptyrow

  1. C

    VBA: How to assign value of named range cell to external file?

    Hi, I am trying to transfer data to an external file from a worksheet using VBA: current date, username and a global range named cell "Score". Date and username is succesfully transfered to column A and B in the first empty row. "Score" however gives me an error. I don't know how to refer to...
  2. B

    VBA: Find and add data from userform to first empty row in sheet (not working)

    Hi guys, I'm having trouble with a macro. I have a worksheet with lots and lots of macro and they work perfectly together. However, this code (which I've shortened, because of its length) isn't working properly. I have a sheet full of data for my reservation program. First names, last names...
  3. P

    Update Row when ID is found

    Hi I have the code below for the ID which is textbox18, what I want is if a person has an update they go into the userform and enter the number id then what they want updated in other textboxes and then click the update button. what this should do is find the ID in sheet1 and update the same...
  4. P

    Adding N/A to empty textboxes in userform

    Hello, Good afternoon please can you help me I have the code below where I am trying to add N/a to the empty textboxes in my userform if not filled but I am getting an error, please can you help me? I am getting an error on Conventional.Show Private Sub CommandButton3_Click() Dim...
  5. P

    multiple cells with email addresses add to code

    hi i have the below code where i want to add a range to the email address located in sheet (email links) i have done for example the A2:A20 but this doesnt seem to work it only find the email address in A2 and not in A3, A4, A5 etc, please can you help me wioth this? thanks for your help it is...
  6. P

    Adding a range error plz help

    hi, i got the code below where i want to add the data from A38 - K38 but i keep getting error 'Run-time error 91 - object variable or with block variable not set' please can you help me with this? Private Sub OKButton_Click() Dim emptyRow As Long With ThisWorkbook.Sheets("Northants")...
  7. D

    Inefficient Code

    Hey all, Thought I'd give you folks a good laugh, perhaps even a hard cry by taking a look at the "Submit" button i have in my ever growing user form for an Order Follow up system. This is a multitude of other's work stitched and sewn together over the years. Everything is working, and it's not...

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