excel - Changing Wide Data back to Long Format - VBA. How to Select Sheet? -


i have been looking wide long format code while , found on here useful. have took , made modifications apply data... works perfectly.

my question though is, add in sheet selection? i.e. want able run macro button on different page. @ moment code works if executed orignal source sheet.

sub wide_to_long()  dim rng range, dn range, dta, col integer dim c integer, lastdt integer, lastvis integer  lastdt = cells("1", columns.count).end(xltoleft).column set rng = range(range("a2"), range("a" & rows.count).end(xlup)) redim ray(1 rng.count * lastdt, 1 lastdt) each dn in rng   lastvis = cells(dn.row, columns.count).end(xltoleft).column       col = 8 lastvis         c = c + 1             dta = 0 8                 select case dta                     case = 7                     ray(c, dta + 1) = cells(1, col)                     case = 8                     ray(c, dta + 1) = dn.offset(, col - 1)                     case else                     ray(c, dta + 1) = dn.offset(, dta)                 end select             next dta     next col  next dn sheets("sheet2").range("a2").resize(c, lastdt).value = ray  end sub

there better (if lowpar know make change), found inserting before first dim sheets("").select sheet data rang on worked fine.


Comments

Post a Comment

Popular posts from this blog

javascript - Knockout pushing observable and computed data to an observable array -

i trying push multiple data (firstname , lastname), along when compute firstname , lastname , try push data in same array thrown error. below code. viewmodel: var viewmodel = function () { var self = this; self.gameofthrones = ko.observablearray ([ {firstname: 'jon', lastname: 'snow'}, {firstname: 'robb', lastname: 'stark'} ]); self.firstname = ko.observable(''); self.lastname = ko.observable(''); (var i=0; i<self.gameofthrones().length; i++) { self.gameofthrones()[i].fullname = ko.computed (function () { return self.gameofthrones()[i].firstname+" "+self.gameofthrones()[i].lastname; }) }; $('#classic').click( function() { self.gameofthrones.push( {firstname: $('#fn').val(), lastname: $('#pr').val()} ); }); } ko.applybindings(new viewmodel()); html view: <form class="" action="index.html" method="post"...
Read more

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

Trouble making a JSON string -

i'm trying upgrade existing json structure more complex one. the original idea bunch of x animals , each 1 having bunch of caracteristics: animals animal 1 claws:4 eyes:2 animal 2 claws:0 eyes:6 etc. the json this: { "animals":[ {"claws":"4", "eyes":"2"}, {"claws":"0", "eyes":"6"}, etc. ] } so can see, don't name each animal object, caracteristics of animal element of array. can use them in loop animals[x].claws now want add nest each animal, like: animals animal 1 head eyes:2 ears:2 body claws:4 tails:1 legs:4 animal 2 head eyes:6 ears:0 body claws:0 tails:0 legs:8 but didn't manage without naming each animal object (with same name "animal") , using arrays what's in animal: { "animals":[ {"animal":[ {"head": ...
Read more