find cell

Hello, I am having trouble determining the code for this logic: -Select sheet2 -If Sum of CN16:CN24 > 0 Then -Select cell with max value within range CN16:CN24 -Copy cell contents -Clear cell contents (important) -Select sheet1 -Paste copied value in cell G5 Thanks for any help!

I would like to use the name of activesheet to enter in data on other sheet on corresponding name, but without selecting or activating that sheet. I have a working formula below, but is there anyway to avoid selecting the other sheet? Sub mark() Dim findx As String findx =...

Hi guys, good morning! This is my first thread here at MrExcel.com. I've been searching the web for help on VBA for the last weeks and learned a lot already! However, when it comes to using VBA, I can say that I'm still "crawling"! What I would like to ask you guys is what kind of function I...

Hi I am very new to VBA and need some advice. I have a table where in Column F only a few cells are filled. I am looking for a code that can find all filled cells from F2 till F59 and copy them to a textbox or label in a userform. Somehow all other tips O found online did not work. So far...

I am new at VBA and need some help with some code I am working on. Here is a sample of my spreadsheet: <TABLE style="WIDTH: 160pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=213 border=0 x:str><COLGROUP><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768"...

Hi I need help with programing a macros to go down a cell until it finds a grey colored cell. Is it possible? So far i have the following: Sub AlimentaciónPanelLegacy() Dim LC As Long Dim RC As Long Sheets("Action Items").Select Range("C1").Select Do Until ActiveCell.Value = GREY COLORED CELL...