-
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.
.rangeb
-
D
textbox value in one column next to the first item of a listbox in another column
Hi all, Does anyone know the lines of code that would allow me to put the value of a textbox1 from a userform in the column A just next to the 1st item of the listbox1 that is displayed in the column B ? It drives me crazy.. Here is the code of the listbox 1 For b = 0 To ListBox1.ListCount -...- Doflamingo
- Thread
- .rangeb code column item textbox
- Replies: 7
- Forum: Excel Questions
-
D
Merge cells in column A in function of the number of items written in column B
Hi all, I’m looking for the lines of code that would allow me to merge cells in column A where the number of cells merged in that column represent the number of items written in the column B. Here is the code of the listbox 1 and listbox 2 that put items from those listboxes in the column B...- Doflamingo
- Thread
- .rangeb cells column nextrow number
- Replies: 12
- Forum: Excel Questions
-
R
VBA Apply Formula if Certain Criteria is Met
Hello. I'm looking for some help. I would like to apply a formula to a specific sheet, column "R" if a specific name appears in column "B". I have tried the code below, but it is inserting the formula into column "R" for all rows, regardless of name. With Sheets("RetailBack") Dim...- rsmeyerson
- Thread
- .rangeb column formula lstrw specific
- Replies: 14
- Forum: Excel Questions
-
B
vba to find a date in a range to upload the userform data into that row
I am having a bit of a headache and I've found this forum very useful in the past however I can't find a clear answer for this one anywhere. Apologies I am a novice at this so please bear with me. I have put together a userform and a spreadsheet for it to be uploaded into. The problem I have is...- bigbertha98
- Thread
- .rangeb date nextrow.offset0 row upload
- Replies: 3
- Forum: Excel Questions
-
E
VBA - Skipping a Value
I am trying to write a value of 0.00 to a cell, (Per Textbox2) but it keeps skipping over the value and not writing anything in the cell. I tried stopping the code and it shows up as .000 per the textbox2, but it jumps to the end of the statement. If I add a value of .001 it works, but 0...- Evapar18
- Thread
- .rangeb enabled end rw.value textbox2
- Replies: 9
- Forum: Excel Questions
-
H
Application-defined or object-defined error
Hi, I am getting said error on this line: Of this macro: That I jacked from this topic: https://www.mrexcel.com/forum/excel-questions/685654-simple-macro-cut-paste-based-cell-value.html I am wondering if anyone can help me to diagnose the problem. I'm new to Excel and not entirely sure...- Heather_Llo
- Thread
- .rangeb destination=sheetsneed e-mail.rangeb end long
- Replies: 5
- Forum: Excel Questions
-
V
Only copy Column B (INCLUDING THE TITLE ROW) to the last row of data in Column A
Hello All, I have this code below that copies Column B, but it starts in cell B2. I need it to copy the title row (Cell B1) as well. .Range("B2").Copy Destination:=.Range("B2:B" & .Range("A" & Rows.Count).End(xlUp).Row) I tried this... .Range("B:B").Copy Destination:=.Range("B:B" &...- VBAProIWish
- Thread
- .rangeb column copy row title
- Replies: 11
- Forum: Excel Questions
