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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top