linecount

  1. T

    Looping with a Worksheet Function

    Can anyone point put what I am doing wrong here? I want to loop through a few rows on one tab using a worksheet function to return countif and sum values. I'm getting a Method "Range" of object "_Global" failed error when I try to run it. This was working before I tried to add I + 9 to...
    • termeric
    • Thread
    • function linecount linesum loop sheetssheet1.celli
    • Replies: 2
    • Forum: Excel Questions
  2. H

    Run time error '53': File not found

    Dim wb As Workbook Dim ws As Worksheet Dim objFSO, strTextFile, strData, arrLines, LineCount Dim ReceivedTrans, Mis As Integer Dim MyFolder, MyFile, MyFileName, MySheetName, ReportDate As String Dim FileType As String Dim i, j As Integer Const ForReading = 1 i = 1 j = 1 Set objFSO =...
    • haribole
    • Thread
    • dim do while loop problem linecount myfile objfso
    • Replies: 14
    • Forum: Excel Questions

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
Back
Top