Get instant live Excel expert help to learn how to find range in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a vba error.
Subscript out of range
Sheets("Harvest Data").Range("A2:N10000").ClearContents
Solved by F. Y. in 14 mins
hi, I am looking to create a conditional format that will look up a name on one sheet, along with absence start and end dates. Once it has done this I want it to turn all the dates between start and end red on my other sheet that is laid out in calendar format. Is this possible . Also the name could be found on several occasions of which I would need it to return all dates and not just the first in the range. Hope this makes sence
Solved by B. F. in 24 mins
a dynamic range I have created is not picking up all the data
Solved by S. L. in 29 mins
i have this formula set up ...=IF(COUNTIF(AW24:AW26,1)>0,1,0)
so anytime a 1 is in the data range, it shows up as 1. i want to modify the formula to whenever a 1 or greater shows up
Solved by G. B. in 22 mins
I am trying to make a graph with a selected data set. On my x axis i have a large value range...however this value range will change with depending on the person using it. I want to build it to where they dont have to select the range for the variable...but i dont want the legend at the bottom to show all the unused variables
Solved by Z. F. in 17 mins
Hi I am trying to combine a sumif and a vlookup and struggling!
I would like to do the sum of a column if it meets one criteria and can successfully complete the formula but I would also like it to divide each of the cells in the sum range by the rate of exchange in another table the currency for each row of the figures to be added up is in a column to the left...
Can you help please?
Solved by O. J. in 25 mins
Insert a new blank row 1. In cell A1, type Schedule of Academic Events with Unassigned Judges and then Merge & Center the title across the range A1:M1. Apply the Title cell style
Solved by B. H. in 21 mins
Select the range A2:M49 and apply the Custom table style—Academic Team Schedule.
Solved by B. Q. in 19 mins
i want to copy formulas from a range that pull from a tab
Solved by K. U. in 26 mins
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lRow As Long
Dim vaData() As Variant
If Intersect(Target, Range("A1:A200")) Is Nothing Then Exit Sub
ReDim vaData(1 To 1, 1 To 3)
vaData(1, 1) = Now()
vaData(1, 2) = Target.Address
vaData(1, 3) = Target.Resize(1, 1).Value
Application.EnableEvents = False
With Sheets("Sheet2")
lRow = .Cells(Rows.Count, "A").End(xlUp).Row + 1
.Range("A" & lRow & ":C" & lRow).Value = vaData
End With
Application.EnableEvents = True
End Sub
presently i have to enter manually i need help to make this automatic.
i donot know much about excel,this is done by one of my daughters.
regards
kamal
Solved by E. Y. in 20 mins