.cells

Hi, Below is a nested loop that 1) loops through a list of worksheet names, 2) gets the last row of data from each sheet and 3) is supposed to aggregate each row of data into a DashBoard sheet by transposing it. I am trying to get each subsequent bit of data to get pasted into the next column...

I am hoping someone is able to help me complete this puzzle ... I know what I need to do, just not how to do it efficiently. I have several rows in my database. Columns "R" and beyond may hold hold text values. What I need to do is combine all the values from column "R" to and including the...

I am having issues getting a line after the loop that will offset 16, then look for the maximum value in that column and add 1 to it. I have been trying since and the best result was to get to that column but what it placed there was not what I needed. Please help::confused: With Sheet1 Set...

Hi Guy's I am new to VBA, this is was my first trial on programming. This was inventory system to detect location and status of my item. I have several problem can't solve so far. 1) Un able to search by SN and update/edit when using button on Userform 2) Problem to delete cells on Coloum...

Hi all, It's been just over a day since I have been learning VBA. I want data to be navigated from the entire workbook, not worksheet. I would like to add Prev/Next btns to my userform that will navigate records, I want the data to be displayed in textboxes as buttons are selected. I would...

Dear all, Can somebody tell me why .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula = "= " & .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula & " + " & .Cells(646 + daysconcerned, 18).Value results in an error? The error code is 1004: error defined by application or...