specific cells

  1. E

    Copy and Paste specific data vba code

    In the below code I am trying to look through my data for a specific name and then cut that data and paste it into a specific cell but I am getting an error on the last line. the error states: runtime error 438 object doesn't support this property or method. Can anyone help me see what I am...
  2. L

    AutoSave using specific cell(s) to rename and to a specific location

    Noob to VBA here, apologies in advance. Haven't even thought of macros in years, and searched the forum and can't quite piece together the parts to what I need. I have a spreadsheet for daily jobsite use...completed by the crew and used by internal departments for payroll and billing. Boss is...
  3. W

    Insert a row with specific contents after every merged data cell.....

    Hi all I've looked online for VBA code to insert a row with specific contents (ex. 'Example1' after every merged data cell (it should check for data) in a specified range (B13:B269), but none seem to work properly with the merged cells. Column B has merged cells, but column D does not (Column C...
  4. S

    Look up particular row information if cell value matches specified value

    Hi all :) I have two worksheets, one named Data and one named Index. In column G of Data, there is an index number. In column G of Index, there is a list of special index numbers. In columns A:F there is information about each special index numbers. What I need is in Data, if the index number...
  5. S

    Only keep rows that have a range of specified values in a particular column

    Hi all :) I have a dataset with 34 columns and ~5000 rows. In column G there is an index number. The index number goes down the column, increasing by 1 each time, eg in G2 the index is 1, in G3 the index is 2, in G4 the index is 3. . . Data worksheet <tbody> Columns A, B, C, D, E, F G -...
  6. C

    Browser URI to open Excel at a specific Cell

    Hi all Is it possible to create a browser URI to open a excel workbook at a specific cell? Thanks in advance Michael
  7. A

    Search specific text and past in specified cell

    Hi, Any help is appreciated on this query. I have a sentence in column C (Sheet1) and I need to search a specific text which is placed in Sheet2 Column A1 till A100. I am trying to check if Sheet1 Column C has the text from Sheet2 Column A and place that text in Sheet1 Column E. For...
  8. sir_smee

    Excluding specific cells from printing

    Dear Excel gurus, Background: I have a single-page sheet I use for cash-up purposes, upon which I have added a short sentence explaining to my staff which buttons to press to run a macro.:confused: Question: How can I exclude this instruction from printing when they print their reports?
  9. M

    Extra data (specific cells) from various close workbook

    I am pretty new with VBA - am actually an accountant. But help is needed. As the subject says, I need data from specific cells of various cloded workbooks and the data have to show a a summary sheet at various specific cells. ie. data from A2 (closed workbook 1) must show in C3 (in another...

Watch MrExcel Video

This Week's Hot Topics

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
Top