-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
naming cell in vba
-
D
Macro to copy and save cells by name to new workbook
Firstly, thank you for the invaluable information I get in here. I am no graceful in my macros but they work so i can't complain. I have 4 Questions I have a purchase order macro. Command Button is clicked and it opens a workbook and saves selected cells to next available row and saves workbook...- Danin
- Thread
- Replies: 1
- Forum: Excel Questions
-
E
Name A Cell in VBA
Afternoon all, Within my macro I have looped downwards to find the next empty cell. I then need to go back to this cell location (i.e. B6) later in the macro and many times. How can I go back to this cell location without performing the loop again? (which will make the code long and make the...- evil_moses
- Thread
- Replies: 9
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...