VBA assign a range to an Array from different sheet -

-

i have 2 different sheets , have assign 2 ranges these 2 sheets 2 different array problem can not specify sheet before range e.g 

dim flarr() variant  flarr = sheets("xxx").range(a1:a10)

this gives me error. workaround?

thanks

look @ differences between code , mine. remove parenthesis after variant variable, let excel figure out array. need include range in quotations , specify want values range.

dim flarr variant flarr = sheets("xxx").range("a1:a10").value

hope helps :)

you less common construction this, awkward.

dim arr() variant redim arr(1 10) arr() = sheets("xxx").range("a1:a10").value

hope helps


Comments

Post a Comment

Popular posts from this blog

java - unable show chart in xls document using jasper reports -

-
Image
i new jasper reports . able export data through jasper reports excel sheet. when created pie chart in ireports , showing on preview. when write below code in jsp file view report in jasperviewer , shows data along chart. when try save document (that in jasperviewer, gives many ways of saving report either in pdf or rtf or xls) xls error came in console net.sf.jasperreports.engine.jrexception: cell cannot added. however when remove chart .jrxml file, able export data excel file. read jr chart inserted image in excel document. xls document not taking images. below jsp file: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1" import="java.sql.*,java.util.*, net.sf.jasperreports.engine.*,java.io.*, net.sf.jasperreports.engine.design.*, net.sf.jasperreports.view.jasperviewer" %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html...
Read more

javascript - How to change image src on success AJAX -

-
the form: <form action="/user/updateprofilepicture" id="uploadphotoform" method="post" enctype="multipart/form-data"> <button class="btn btn-onetraffic btn-responsive btn-large">+change photo</button> <input class="btn btn-onetraffic btn-responsive btn-large" style="opacity: 0; height: 34px; margin-top: -34px;" type="file" id="uploadphoto" name="file" accept="image/*"> </form> div want image source changed: <div id="img-container"> <img id="upslika" src="#"/> </div> i images url server through json i tried : success:function(){ console.log("success"); $("#upslika").attr("src", res.pictureurl); }, res response the success callback must this: success: function (res) { ...
Read more

java.lang.RuntimeException: Could not generate dummy secret at sun.security.ssl.RSAClientKeyExchange.<init> -

-
i working on java ee application (netbeans ide 8.0.2, glassfish 4.1, jdk 1.8.0_45). the access pages of application should secured https, modified web.xml : <security-constraint> <web-resource-collection> <url-pattern>/*</url-pattern> </web-resource-collection> <user-data-constraint> <description/> <transport-guarantee>confidential</transport-guarantee> </user-data-constraint> </security-constraint> when deploy & start glassfish via netbeans can access application via https://localhost:8181/myapp/ when bundle application in .war file , deploy manually copy of same glassfish installation files netbeans uses, exception while trying connect application: warning (35) grizzly0013: exception during filterchain execution java.lang.runtimeexception: not generate dummy secret @ sun.security.ssl.handshaker.checkthrown(handshaker.java:1429) @ sun.security.ssl.sslen...
Read more