title: find size of external monitor in excel vba
body: <p>To find the size of the monitor, I've been using:</p>
  
  <pre><code>Declare Function GetSystemMetrics32 Lib "user32" Alias "GetSystemMetrics" (ByVal Index As Long) As Long
  </code></pre>
  
  <p>and then:</p>
  
  <pre><code>Function getMonitorSize()
    monitorHeight = GetSystemMetrics32(1)
    monitorWidth = GetSystemMetrics32(0)
  End Function
  </code></pre>
  
  <p>This works fine for the main monitor, but how do I find the size of an external monitor?</p>