PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 [89] 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Set to default browser
  2. Copy, Paste Special and Insert
  3. Solved: worksheet change event
  4. Solved: Detecting a Running Application
  5. trim & dates
  6. Solved: Copy based on multiple condition
  7. Code to print folders, subfolders and files
  8. Solved: VBA alternative to a look up table
  9. Solved: Calculation of an UDF
  10. What's wrong with this code?
  11. Excel 2007 find last column in table
  12. Make a cicle
  13. Solved: Challenging Question* Need excel macro to send email based on a choosen number
  14. Solved: Mysterious macro running on Excel file close?
  15. COMPARE 2 XL WORKBOOKS & PASTE DATA
  16. CTRL + Break
  17. Solved: Cells vs Range
  18. Rich Text Box
  19. Using wildcard in folder name
  20. [SOLVED:] List data
  21. Solved: CheckBox Help
  22. Basic question on cell comparison
  23. Conditional formating of rows
  24. Scrollbar controlling several Textboxes?
  25. OWC11 Spreadsheet component Undo Error
  26. Lookup Macro Help
  27. Print active sheet from printpreview-excel 2007
  28. Solved: SUMIF attempting to interrogate cell properties in "criteria" portion of the syntax
  29. VBA Code to check if shared document is locked for editing
  30. If blank column, paste to the next column VBA
  31. Excel VBA for creating Folders
  32. request for complex examples for combination of function
  33. Solved: excel 2003 conditional formatting
  34. Refresh Sheet1 or workbook periodically
  35. Solved: Delete Row based on Column Criteria (with looping)
  36. populate combobox using array
  37. Add lines in excel comments through VBA
  38. Solved: When a row inserted, add one to highest Value in Col N, & add -1 to Col B value
  39. Print Visible data rows
  40. Can I block an .xlsm from being converted when it's open in Excel 2003
  41. "Out of Memory" error thrown when Formula contents length exceeded
  42. Solved: Programmatically naming an offset cell....
  43. Filter several pivot tables for same value
  44. Blank Columns
  45. Solved: Autofill formula VBA needed
  46. SOLVED: Send email using vbs without attachment
  47. Solved: Userform value problem
  48. count instances if within 30 days
  49. Get javascripts from a URL with VBA
  50. Detecting the class in a span
  51. Reading Data from Excel 2007 (?????)
  52. Replacing columns and rows default names
  53. Solved: Is it possible to enter a UDF into a cell and replace it w a native Excel formula?
  54. Collating data into a consolidated view
  55. Formula Update
  56. Solved: how do I save an xls as an xlsx after changes are made in VBA?
  57. Array help
  58. Solved: Need Zip code `
  59. Why doesn't this work in a loop?
  60. Compare one number with list of numbers
  61. VBA Module
  62. Modify code to run on multiple files
  63. Autofill issue
  64. Solved: What is wrong with this code???
  65. Solved: Cell Value As String
  66. Append data in master file from 4 different files
  67. Solved: Restrict Special Charachters
  68. Very complicated, copy and paste sheets in a loop
  69. Solved: Change Path -- ActiveWorkbook.path
  70. [SLEEPER:] list all running programs
  71. Copy to last row with unspecified column
  72. Solved: Cell Reference
  73. excel connection
  74. [SOLVED:] Simple question...
  75. Sum columns in table excel 2007
  76. Copy Array of Values
  77. Problem with Changing formula
  78. Get Cells to flash based on a condition
  79. Solved: Adding conditional formatting VBA
  80. Solved: Message box for offset column
  81. Open Gmail
  82. Solved: Floating command bar position
  83. LOOKUP?? how to find data (stuck on project..please help)
  84. Solving a problem within VBA without using solver
  85. Solved: Delimiter saving each tab to its own .txt file
  86. HyperLinks to specific Location in another App.
  87. [SOLVED:] Solved: download complete
  88. Carriage Return Quote Delete Macro
  89. Solved: Emailing From Excel Using an Outlook Template
  90. Help from Guru needed
  91. [SOLVED:] Get all the names in the column
  92. UDF randomize an array
  93. Macro to trim and convert in excel
  94. Solved: Print Settings
  95. Looping through workseets issue
  96. Solved: cutting date into variables
  97. Need quick help with some VBA issues (image sizing)
  98. Multiple If statements in 1 column
  99. Help With VBA in Excel ? Writing a function using probabilities ?
  100. [SOLVED:] How do I Insert 2 or more rows with a copy from one other row?
  101. Split Cell Content Into Two Columns
  102. Sharing a macro that is created by me
  103. Solved: What's wrong???
  104. A Short Formula Please - Excel
  105. iterate till equilibrium reached
  106. Solved: variable ProperCase
  107. Solved: Address
  108. Solved: Match Name find Row No then copy values to sheet2
  109. Solved: VBA Code, who can help?
  110. Solved: Embedded Spread Sheet
  111. Macro: look up another field and pull the data not matched
  112. Created a Drop Down Box based on certain criteria!
  113. Solved: InputBox Help
  114. [SOLVED:] How to Throttle SMTP Traffic
  115. How to delete a Empty column?
  116. problem with excel 2010 slicers
  117. Solved: Code for vba to replace below formula
  118. Solved: Data Validation List shortcoming(s)
  119. Form position
  120. Solved: How many substrings returned by Split() ?
  121. Solved: CNTL + N
  122. Solved: Total sum of Time in a column
  123. looking for value position in table
  124. Solved: caption SaveAs location
  125. on change event according to pivot table
  126. Does VBA Lose Variable Definitions and/or Values between Subs?
  127. [SLEEPER:] excel - checkbox
  128. Solved: Label display
  129. Solved: conditional formatting
  130. [SOLVED:] Set Msgbox with Default number?
  131. [SOLVED:] Add a WebService reference to an Excel 2010 sheet
  132. Compare dtmDate with a value in column A
  133. Data Validation C2*D2 = E2
  134. Modifying Code for Whole to Flash
  135. Change all pivot table data sources
  136. Generating one .TXT archive from the Sheet.
  137. Solved: Activate certain sheet based on cell content
  138. Control Inputbox as number only?
  139. Copying the entire workbook to a new workbook
  140. Check Cell for Blank
  141. Solved: Macro's slowing down my spreadsheet
  142. Override the built in SAVE
  143. Application.Volatile Method
  144. Need some newbie help with Cell validation
  145. Solved: Click on protected sheet
  146. Reordering rows where sort is not effective
  147. set calendar to open at a specified date.
  148. Solved: Not sure how to fix this loop? Help Please
  149. Forgot the password I gave to protect a part of sheet
  150. Error: Object Variable or With block variable not set
  151. Userform Validation - Unique Names & Numbers
  152. Can anyone improvise this data and chart?
  153. Which FileFormat code (enumeration) for XL 97-2003 ?
  154. Data Validation - "A" and 2 number and 2 letters
  155. Solved: Fill by number of rows
  156. Macro: Need to find all unmatched Data
  157. Solved: Delete row if default value
  158. Assign Value to Variable Type Range
  159. Solved: slow macro
  160. how to use VLOOKUP only for blank cells in column A
  161. Excel VBA Access
  162. Lock Cell Format?
  163. Solved: Open workbook to last Friday of current week
  164. Solved: Unable to change the name of this cell
  165. Solved: display worksheets in combo box except...
  166. ref range to replace sheet name
  167. [SOLVED:] Copy worksheet with referencing old worksheet
  168. Macro's for printing
  169. Convert String To Date
  170. Solved: General questions on excel objects...
  171. Messagebox to remind user of 12 day limit
  172. Solved: Loop with Go to steps?
  173. Getting a 0 When Dividing
  174. Loop through folder of Excel files and copy sheet from one set into another
  175. Macro: Move Cells where QTY is in upper percentile
  176. Solved: An error with setting a wb. Why?
  177. [SOLVED:] Copy and rename sheet in sequential order
  178. Lock Cell after value updates to specific value
  179. Select sheets based on name
  180. Loop web query
  181. Solved: How to import multiple sheets from different files in same folder to main workbook
  182. Creating an OnClick event for an autopopulated userform
  183. Writing a .CSV file (.txt) from a Sheet
  184. Solved: Delete Row Based On Value
  185. Solved: Shortcut to run macro
  186. Set a value from different sheet in other sheet
  187. efficient way of comparing whats already in a collection
  188. Solved: Summing to a target
  189. [SLEEPER:] Want to use vb YES/NO question box
  190. .xlsm row restrictions?
  191. Copy And Compare vs Switch And Compare
  192. xlt question
  193. [SOLVED:] Dynamic Procedure call
  194. Find and delete
  195. Embedded Spread Sheet - Span to next page
  196. Loop A Script
  197. Solved: Hide/Show Rows based on % character in cell
  198. Macro names changed in V2007
  199. Print Macro and Cell to Populate from table Help!
  200. [SOLVED:] Excel keeps freezing for about 5-7 seconds
  201. Solved: Excel VBA to select rows after Pivot Table
  202. VBA to automatically run
  203. [SOLVED:] Test for empty directory - odd result
  204. Solved: Formula to return latest date
  205. Solved: Display following year in combo box
  206. Can you force code to run in order?
  207. Eliminate unwanted data...
  208. Macro help!
  209. Split Text file data
  210. Solved: Why i get Vba Error in this code??
  211. Dynamic Array
  212. data validation - number or number / 2
  213. Solved: Calendar pop up with date AND time
  214. Linking 2 Combo Boxes Together?
  215. Not Sure How To Title This
  216. Font red and Bold specific dates returned on email sent.
  217. auto set page break to last row with data
  218. Solved: Making Scripts More Efficient
  219. Help on merging wbksheets
  220. Format Percentage Problem
  221. Excel Lookup Problem
  222. Can I use vba to set page breaks and fit the sheet’s data to 3 pages?
  223. Solved: Lose formula reference in active cell
  224. Read date and time from active cell to a date picker
  225. [SOLVED:] Display logo pasted to worksheet as icon on desktop shortcut
  226. Solved: Add name to combo box
  227. Solved: "If FileExist" isn't seeing the file
  228. dissable richt click page setup
  229. Hovering text not disappearing after click
  230. Solved: select previous sheet that I viewed
  231. Integer & String
  232. Solved: Relying on Exit Sub too much
  233. Solved: create notepad
  234. How to Lookup data from different sheets to single workbook
  235. Solved: IF Statement doesn't work
  236. Solved: Date format changing when pushed to SQL Server
  237. Solved: Delete rows if cells in multiple columns are blank
  238. Generating a simple report based on some criteria
  239. [SLEEPER:] Remove conditional formatting but keep format
  240. Solved: VSTO
  241. User Form
  242. Change cell color from user form
  243. Solved: Clearing Pivot Cache
  244. Solved: Worksheet_Change with 2 requirements
  245. How to LinkColumn of a Saved Workbook
  246. Command Bttn import .csv file to new worksheet
  247. Two questions: Long and Dim
  248. Pasting a selection of data
  249. Solved: Solved:
  250. Get current keyboard layout with VBA