activecell.value

  1. W

    Change macro stops

    I wrote this program to take some data that was being transferred to my tablet through a keyboard wedge software and put it into our inspection sheet. It takes data from a few different types of inspection eq and the data string was different for each so I had to pull the number from different...
  2. B

    Creating customer statement and email with xls attachment

    Hi all I am new to this forum. I have seen some pretty amazing VBA codes/help here. I would like to get involved. I am a management accountant and I often create workbooks for myself and colleagues to save time and improve efficiency. To start off, I am sharing the following code which I...
  3. A

    runtime error 438 after opening workbook with vba

    Hi Everyone, First ever post so apologies if i'm doing this wrong. I have written some code that in theory is supposed to after being passed a filename selected from a list box(Listbox1) and a directory as a string (MyFolder), use these to see if that workbook is open. If it is then it copies...
  4. A

    id not auto increment and data overwritten using loop

    Hi everyone, I"m still new in VBA and currently working on to develop data entry form in excel. I'm facing errors where my ID cannot auto increment while inserting the data=Country with 10 rows once the button was clicked. My codes are getting errors by overwritten the previous data for next...
  5. G

    Unknown error - crashes workbook everytime."

    Hi all, Sorry to bother people with this, but I cannot seem to find what keeps crashing Excel in the following code. I already know the code is horrendous to look at as i'm not amazing at this, so if anyone could provide tips on keeping it efficient that would be awesome too. Private Sub...
  6. K

    Excel VBA getting table columns by name in a specific sheet within a closed workbook

    Hello everyone, before I wish to explain my question, I want to say that this forum has helped me a lot solving my automated excel obstacles :) So right now, I have this piece of code that simple asks the user for the workbook location, name and sheet name in order to fetch the entire sheet...
  7. A

    VBA Active Cell Debugging Issue

    Hi, Need your help and assistance on the debugging issue I encountered. I've been using a code that runs smoothly when generating the Macro. But when I run the program again using another data, debug issue occurs. I've run series of data combination with one sheet and some run smoothly, but...
  8. H

    one by one as if do it manually

    Hi all , I have one simple question in fact it's stupid too. i have loop code like below . all i wanted is the code is working fine but i wanted the code to run slowly as if we do it using F8 . like as if we doing it manually one by one i tried all the steps but could not figured it out hence...
  9. L

    VBA: Double quotes in export CSV

    Hi Guys, I have a piece of VBA which is exporting a sheet to a CSV file. I want this CSV to be comma separated with double qoutes around every column. At this moment I get comma's as separator, but I don't know how to get the double qoutes around the text in the columns. This is what I have...
  10. K

    What is the ActiveCell.Value of a wrapped cell

    Excel experts, I am new to the forum and this is my first post. I have read the rules and guidelines, and I will do my best to follow them. I apologize if break any rules. I am working on a macro that searches for certain cell values. I am struggling with the correct syntax of the cell value...
  11. D

    Remove quotes from text pulled from CSV

    Hi all, Need to pick someone else's brain on this. The problem is very simple: I have a macro which is extracting information from a csv report and populating a spreadsheet. The problem I have is that when it does so the text populated on the cells are all double quoted: "14/07/2015 9:51:37"...
  12. L

    Replacing Range of Selected Cells using VBA

    Hello everyone, I'm currently using the following code for a macro that replaces the one and only active cell's space for an underscore: Sub Hello() 'Finds and replaces spaces with an nothing ActiveCell.Value = Replace(ActiveCell.Value, " ", "_") ActiveCell.Offset(0, 1).Select End Sub...
  13. S

    Activecell.text on a Hidden Cell

    Got a bit of a strange one. Looping through a group of cells, and if the cell value is blank, I want to put a value in the cell (in this case, 0). Heres the problem. When the cells are visible, it works fine. When the cells are hidden, the activecell.text is equal to "". If I run the code...
  14. C

    Renaming a merged cell

    Hello, I'm trying to rename a merged cell and I'm getting the following error and the last line of the code is highlighted when I debug: Run-time error '70' : Permission denied Sub RenameCell() ' ' ' Sheets(Sheets.Count).Select Cells.Find(what:="general ledger"...
  15. dukeofscouts

    UserForm Opening set values to contents of activecell.value

    I've been toying with Userforms for about a week now. Thanks to google I've been able to find lots of help with trouble shooting most of my issues. However, this one has me stumped. When I run the macro to call the userform, it says that the Find function is not recognized. According to all the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top