-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
rng.offset
-
M
Select file to pull data from
Hi all, I was given a great piece of code the other day to help pull a range of data from several worksheets in a fixed location. This works great but now my boss has asked me to do something similar for another spreadsheet but this time the the source where I want to pull data from is...- Mikeymike_W
- Thread
- .sheetsglobal dim pull data rng.offset select file
- Replies: 4
- Forum: Excel Questions
-
B
how to deal with offset
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> A 14 B 16 C 68 D 0 E 32 F 25 G 25 H 55 </tbody> Sub using_the_resize_property_to_change_thesizeofRangeMethod1() Set Rng = Range("B1:B15").Find(what:="0"...- bhandari
- Thread
- lookat=xlwhole lookin=xlvalues rangeb1b15.findwhat=0 rng.offset set
- Replies: 2
- Forum: Excel Questions
-
Q
Populate multiselect + options listbox on Userform with previous output
HiFolks, I'm trying to create a userform that will checkto see if information related to the current row had already been recorded to a different worksheet (Worksheet1 is the active one, worksheet3 holds the information),and pre-populate the checkmarks on a multi-select option listbox with...- qapla47
- Thread
- 2.value end instr1 rng.offset thisworkbook.save
- Replies: 0
- Forum: Excel Questions
