mycol

I am using the code below to copy a formula down to the last row in the active sheet. Then copy paste the values. When running the macro on a sheet where the active range is small I am not having any issues. However, when I run the macro on a sheet with 66 columns and 900,000 rows Excel...

Hi, When I run this code. My aim is to have a user be able to pull data based on their selected criteria from the inputbox from a closed file (which isn't going to be opened). That closed file is updated (with a new file name) each week, hence the user having to select the file initially to...

Hi I'm using the MATCH function to return the column number where specific text was found in a row. That number (say 7) is stored in a variable (MyCol). I now want to COUNT the number of values (text and numbers) in column MyCol. How do I do this ? Thank you in advance Al

Hello, Trying to declare some variables in Module, so when i hit commandbutton to take another value (also depending from listbox value) to create a graph in a picturebox, but when i execute the values are 0. Here is the code. Option Explicit Public Function mysub() Dim myrange As Range Dim...