find cell

  1. T

    Find max cell within range, copy cell, clear copied cell contents, paste on another sheet.

    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!
  2. B

    Find cell and enter value on other worksheet without using select or activate?

    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 =...
  3. A

    Search cell to paste value

    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...
  4. F

    VBA: Find cells that are not empty and copy to Textbox

    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...
  5. P

    Find cell and insert formula

    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"...
  6. D

    Go down a cell until it finds a grey colored cell

    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...

Some videos you may like

This Week's Hot Topics

Top