Basic

Search

excel vba chck that the range is empty

Sub TestIsEmpty()
    If WorksheetFunction.CountA(Range("A38:P38")) = 0 Then
        MsgBox "Empty"
    Else
        MsgBox "Not Empty"
    End If
End Sub

Comment

PREVIOUS	NEXT

Code Example
Basic :: bash catch ctrl-c in a script
Basic :: pmatplotlib draw a square with a magenta dotted line and pentagon markersython matplotlib overlaped
Basic :: powershell how to removve only empty direcoties
Basic :: how to capture link cefsharp
Basic :: whats up
Basic :: fill in the commands belllow if you wanted to map a value saved in the variable count from one tange to another
Basic :: visual basic non modal message box
Elixir :: elixir catch
Elixir :: elixir change map key name
Elixir :: elixir get_in access all
Elixir :: elixir pick out elements in list
Scala :: scala hello world
Scala :: foreach batch spark scala
Scala :: scala home set up
Actionscript :: how to resize a base64 image
Excel :: google sheets stack columns vertically
Excel :: convert number to date in excel
Perl :: perl until loop
Perl :: perl mechanize infinite scroll with attempt count
Pascal :: while loop in pascal
Powershell :: Saved Windows Credentials
Gdscript :: godot update value in progressbar
Cobol :: python pygments install
Assembly :: discord bot remove message
Assembly :: import pyautogui Traceback (most recent call last): File "<stdin", line 1, in <module ImportError: No module named pyautogui
Javascript :: jquery vslidation remove spaces from input
Javascript :: filesaver.min.js cdn
Javascript :: ajax cdn
Javascript :: How to get the browser to navigate to a URL in JavaScript
Javascript :: how to find number in string js

Search

BASIC

excel vba chck that the range is empty

ADD CONTENT