specific cells

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...

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...

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...

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...

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 -...

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

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...

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?

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...