I'm looking to select a range of sheets then divide numbers in column "E" by "0.93" and round to the nearest whole dollar.
I'm looking to select a range of sheets then divide numbers in column "E" by "0.93" and round to the nearest whole dollar.
select a range of sheets ...then divide numbers in column E..is your range column E?
is it each number in column E or all the numbers combined?
how many rows?
where do you output?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
According to the information supplied, this should work.
Sub Maybe() Dim i As Long, j As Long For i = 2 To ActiveWorkbook.Sheets.Count With Sheets(i) For j = 2 To .Cells(.Rows.Count, 5).End(xlUp).Row .Cells(j, 5).Value = WorksheetFunction.Round((.Cells(j, 5).Value / 0.93), 0) Next j End With Next i End Sub
Still wondering if it worked or not
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks