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

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