-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
activecell.offset0
-
G
VBA working through subtotal fall overs when only one of of text on last subtotal
I have the following code - (some sensitive information replaced by the word info) which works fine when each subtotal group has several entries, but falls over when there is only one entry. Could someone please help me out. The part of the code where is it specially giving me the 1004 error...- grapevine
- Thread
- 0.select activecell activecell.offset0 end grand
- Replies: 1
- Forum: Excel Questions
-
A
Copy from the next row with macro
Hi, i record a new macro but i faced a problem when i click the button to copy a cell value in the first row from sheet "Marge Carburants" to sheet "recapitulatif" it's copy just the first row and didn't jum to the next cell when i click the button to add an other row in sheet "recapitulatif"...- adelvoira
- Thread
- activecell.offset0 application.cutcopymode false selection.clearcontents selection.copy
- Replies: 8
- Forum: Excel Questions
-
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...- ajcarlos18
- Thread
- activecell.offset0 activecell.offset1 activecell.value issue storepg
- Replies: 7
- Forum: Excel Questions
-
L
copy value from one workbook to another
I wanted to set the file name as variable so that I can copy value from various workbooks to one workbook. While I executed the code below, it asks for name of the file three time. But All I want is one at a time to fill three cells. what's wrong with my code? Thanks! Lan...- Lanfeng79
- Thread
- activecell.offset0 copy values with macro file sourcefilename transfer
- Replies: 2
- Forum: Excel Questions
-
M
Looping through a range of multiple columns
Hi! I couldn't get this to work. I want to right-align the first 3 columns, then I want to do the same thing again, but 5 columns off to the right and so on. I tried the below code, but it seems like it just repeats the align on the first 3 columns? I tried offseting it, but I didn't take :(...- Mufflon
- Thread
- 5.select activecell.offset0 columns ideas offseting
- Replies: 4
- Forum: Excel Questions
-
Writing to A range using a Macro
Good Afternoon Excel Gurus, Need your help with a macro please. I have managed to achieve partially what I need, but what I am after is to repeat the same steps for a range selected in a row. A better option would be to give a popup to fill the adjacent cells (60 or 100 cells) or a range...- sakrams
- Thread
- 1.select activecell.formular1c1 activecell.offset0 macro range
- Replies: 4
- Forum: Excel Questions
-
Better VBA Code to Insert Blank Row and Copy a Cell
Hey Guys - This VBA code works, but just wondering if there is a better way to write it. PURPOSE/GOAL: User can add additional time to a day on a timesheet. Example: Employee works two shifts. Timesheet has In/Out/In/Out columns (4) so when they clock in more than 2x, we have to insert an...- tsroque
- Thread
- 1.select activecell activecell.offset0 activecell.offset1 null
- Replies: 1
- Forum: Excel Questions
