selecting

Dim Lrow As Long Lrow = Cells(Rows.Count, "A").End(xlUp).Row Range("A" & Lrow + 2).Select ActiveCell.FormulaR1C1 = "54_TPL_01_02_Summary" Shouldn't this be finding the last row and then selecting two rows lower? Its not. Its finding the last row and selecting one below it to put...

Hello, i need help from you guys to build a form for calculating bonus. attached is an excel and the required is described below: 1- the target is to get a bonus for a person based on the activity 2- each cell under Bonus Column must equals quantity X value for the selected task 3- the value...

Hi I have two identical tables, one on a sheet named March, another on a sheet named dashboard. I need to return the data from march into dashboard, simply by selecting a month from a dropdown list. I will have the same as march but for each month of the year, by selecting the month on...

Good day all, I have a optionbox within a group on userform. I want to create a button if selected by the user, it automatically selects all optionboxes within that group. Instead of the user selecting each option box individually. Thank you

After Selection.Find.. the whole column in question remains selected/highlit. I don't really want to leave it like that but so far these suggestions don't seem to work in my version 2007 SendKeys"{ESC}" Application.CutCopyMode = False Any other things I could try (apart from selecting...

I've been working on this macro most of day and when I finally get it basically work towards the end I get a run-time error 424 "Object Req." when I am selecting the entire work sheet (cells.select) before I do a replace. I must be missing something simple because I can't figure what DIM for...

Hello everybody. I'm struggling with some problems in selecting a dropdown navigating in Explorer via vba. Above the code, until it works: sub enter_site () Dim myId As String, myCode As String myId = Range("E9") 'user' myCode = Range("F9") 'pw' myURL =...

Dear Mrexcel lovers and helpfull friends. hello please help me urgently with macro i have two columns. A and B i have many rows. but i want to select all even numbered rows (2,4,6,8.....) in two columns. because i have to merge and center these rows in columns in one click. im selecting now...

Hey everyone, Here's a spreadsheet I am working on: https://www.dropbox.com/s/xavhulqwi91xamh/Profitability%20Calculator.xlsx?dl=0. My goal is to make a calculator that is streamlined and aesthetically pleasing as I can. Right now, I have set it up to do the calculations for me, but I have hit...

Hi! I'm trying to select the active cell and all the non-empty cells below it. Can anyone tell me why this doesn't work: Sub Selecting() Dim Lastrow As Integer Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row ActiveCell.Resize(Lastrow, 2).Select End Sub Thanks!

Hi guys. Need some help with an If Statement if you please. =IF(W7="Fail",IF(W8="Pass","A",IF(W7="Fail",IF(W8="Fail","R",IF(W8="",IF(W7="Pass","G")))))) W7 and W8 are combo boxes (Blank, Pass, Fail) By selecting W7 Fail and W8 Pass, it returns A By selecting W7 Fail and W8 Fail, it returns R...

Hey everyone, Just upgraded to Excel 2016. Now, whenever I'm building a formula which references other sheets, I get no visual reference of what I'm selecting. Meaning: when I click on the other tab and begin selecting cells to include in the formula - I get nothing on the screen that shows...

Mango=A1 I tried to do some modification in A1,but it wont allow me to select all I used Ctrl+A,its not working to select the cell data i am keep doing dragging for selecting the whole text. Any solution for this?

Is there a way to lock it from editing but enable selecting the text for copy operation? Thx for help Piotr

Hi all, Im newbie in VBA and i have an issue about duplicate selection. im using this code monthlyfile = Application.GetOpenFilename("Text Files (*.txt), *.txt") in my macro to select a specific file and fetch the data from it. Example: im selecting Jan 2017 file. I need a code to prevent me...

hi i would like an excel macro that would insert a new column to the left of the selected cell only if its not blank for ex, if i'm selecting cell A1 and cell B1 is blank then it should do nothing, if cell B1 has data in it then it should insert a new column in between column A and column B

Hi, I have a data set similar to below <tbody> A B C 12 x x 13 y y </tbody> I am trying to find a code that allows me to selecting the next empty column. This can't use the Range("C12") as every week data gets updated and a new column will be filled with data. Hope someone can...

Hi, I'm trying to create a new pivot table. I'm selecting my range for a pivot table from tab called Mike and area A1...F761 on a new worksheet. However, after selecting my data range, the pivot is actually picking up data from tab Joe area A1..F761 which was previously used for another pivot...

Hi everyone, You are my last resort as this is driving me nuts. I'm running Excel 2016 on Windows 7 and every so often for reasons I cannot determine the active cell highly outline disappears. Issue occurs across numerous workbooks , I cannot detect rhyme or reason to what may trigger this...

I'm working on a code in VBA to copy rows from sheet "ALL FILES" and paste them into "VIEW STUDENT" based on "JOHN SMITH". Right now it copies the entire row, but I only want to select columns D, E, H-AB (4, 5, 8-28) in the same row. Any ideas? Sub RunMain() Dim r As Long, endRow As Long...