range cell

Hello, In the link below some code is hard code referring to specific cells. I thought the source was always going to be the same column, however I just ran it a few times and found a glitch. In this line of codews2.Range("A1").Value = ws1.Range("BL3").Value BL3 was always the cell or so I...

I am having trouble with 2 issues (don't know if 2nd one was fixed because I haven't been able to get past runtime error '1004': Application-defined or object-defined error Here is my entire code: Sub loanDisbursementNotification() Dim lr As Long, x As Long, y As Long Dim strHeader As String...

Hi, I needed some help writing VBA. I need to reference a range of cells (A2:A2357) one by one from sheet 1 to every 4th cell of column D in sheet 2, starting at D2. Please let me know how I can solve this. Thank you in advance for your help.

So, I am trying to write some simple code to select a specific set of cells to center & merge them. It is quite a large set of cells. When I input the cells in my code, I get an error 400 message. I have narrowed the issue down to everything after the the J column set of the cells selected. But...

Hi, Sheet1 has a button that when clicked shows a message box. I would like to show in the message box values from sheet2 withing range A1:A4. This should be in a format of list with lines ... line 1 = cell A1 line 2 = cell A2 . . This range has dynamic values and sometimes some cells are...

First off all, hello everyone! Secondly I'm new to formula and macro so please don't shoot the messenger. I'm trying to build a calendar which keep track of my physical fitness activities. In column A I have, Activity(s) (A9), Distance (A10), and Points (A11). When I type in the word "run" in...

Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Cells.Count = 1 Then Target.Value = UCase(Target.Value) End If End Sub I have this vba to change all lowercase to uppercase in the workbook. However, I would like to use this macro only on c12:c19 and c21:33. Is there...

:) Greetings everyone! The following VBS script has fixed defined ranges. I need the ranges to dynamically change as new rows are added to the worksheets. Sub SATFILTER() ' SATFILTER Macro ' Filters Master Daily Schedule Worksheet for Employees Assigned to Work Saturday. Dim SATFILTER$ Dim...

Hello i have to create a vba code to send email of the first row then next row then so on i have created a vba code but i have few issues the values in COLUMN A SHOULD GO TO THE "TO" FILED OF THE OUT LOOK and B C D E F G H should go to the body of the OUTLOOK please help me out and i will post...

Hi, I'm sorry the title sound weird, I need to use various formulas (or one long formula) with conditional formatting and this is the scenario. I need to display different message if some condition match. i have 3 dates and range that sometime have string sometime is blank Date1 -> Cell G12...

Hi, I have loop, where I want to select column starting from AF till to AQ: AF2:AF100 then AG2:AG100 then AH2:AH100 etc.... .... For i=32 to 43 last_rowx = ws.Cells(Rows.Count, "A").End(xlUp).Row ws.cells(i,2)...??? next i

Hi. i've a excel sheet where i need to perform validations. ex: i've a column by name Item Number. validations to be performed on column is: -> if user enters alphabets, it should display message Item Number should be numeric only. -> it should not be blank -> user should enter value only...

Hi new to VBA and I am having trouble changing my range to select all cells with data. I originally was changing the range to include all possible cells however, this is not the most efficient way. I have tried using last row and a few other formulas but to no avail. I have two scenarios, one to...

I have a loop that goes through data on another sheet to insert into a table. The rest of the code where I add the value to each cell is fine, but the issue happens when every time I insert a new row into the table, the formula I add to that cell affects every cell in the column, not just the...

Hi, I am somewhat of a novice user when it comes to VBAs and UserForms. The UserForm I am using currently is setup with 1 combobox, 3 text fields, as well as submit and close command buttons. The combobox references values D10:D252, and then based on the value selected, is supposed to populate...

Hello. I know this could be a widely discussed question but I deeply looked for an answer and wasn't able to find the best one. I am trying to make a code which fill the value "x" to a range of cells (by columns), based on a single click in one other cell. Moreover i want that one another click...

Hello! I have a range of cells and if i select more than one cell in this range it will reduce my selection to one cell and everything works quite fine until i select for e.g. two cell but the cell right in the vicinity of my range of cells (and this column has a formula) in will select my one...